Wrox Programmer Forums
Go Back   Wrox Programmer Forums > PHP/MySQL > MySQL
|
MySQL General discussion about the MySQL database.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the MySQL section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old January 3rd, 2009, 07:52 AM
Authorized User
 
Join Date: Oct 2006
Posts: 60
Thanks: 0
Thanked 0 Times in 0 Posts
Default how to view my data in my database in a certain items?

Hi,

Im quite new in php mysql, i have a problem regarding on how to view a single item, like for example, im my database i have a table name called "list" in my table i have "id, title,firstname,lastname, status" and id is my primary key, now i have no problem in displaying my data in all, what i want is like for example i have a record in my database like:

--- ID TITLE FIRSTNAME LASTNAME STATUS
view | 1 | REGISTER | JHON | CRUZ | SINGLE
view | 2 | REGISTER | JHON1 | CRUZ | MARRIED
view | 3 | REGISTER | JHON2 | CRUZ | SINGLE

Now my problem is how im going to make a certain code that if i have to click the " view" only in person will appear let say if im going to click view from id 1 only the profile of JHON will display. 1 hope i made it clear. sori my english is bad.

jhanny

how to view my data in my database in a certain items?
 
Old January 3rd, 2009, 09:03 AM
jminatel's Avatar
Wrox Staff
Points: 18,059, Level: 58
Points: 18,059, Level: 58 Points: 18,059, Level: 58 Points: 18,059, Level: 58
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2003
Posts: 1,906
Thanks: 62
Thanked 139 Times in 101 Posts
Default

Please don't cross post:
how to view my data in my database in a certain items?

I deleted your 3rd copy of the question.
__________________
Jim Minatel
Associate Publisher, WROX - A Wiley Brand
Did someone here help you? Click on their post!
 
Old January 5th, 2009, 09:08 AM
Authorized User
 
Join Date: Oct 2006
Posts: 60
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by jminatel View Post
Please don't cross post:
how to view my data in my database in a certain items?

I deleted your 3rd copy of the question.

Hi,

Sori im lost of posting topics i really dont know where should i post my topics...

jan
 
Old January 6th, 2009, 08:16 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

Hi,

You may need to use the ID field as a reference in that.

1 John
2 Peter
3 Sam

You need to have your View links to have hyperlink with a querystring carrying 1 for John, 2 for Peter, respectively.

Thus on clicking View of John's row, you can use the ID value and query the database to show that person's details.

Hope that helps.

Cheers
__________________
- Vijay G

Last edited by happygv; January 6th, 2009 at 08:18 AM.. Reason: Typo corrected





Similar Threads
Thread Thread Starter Forum Replies Last Post
how to view my data in my database in a certain items? jhanny007 PHP Databases 1 March 6th, 2009 12:43 AM
how to view the checked items after navigating madhusrp C# 1 January 24th, 2006 03:28 PM
Help, trying to fill grid w/database items itsajourney ADO.NET 1 May 24th, 2005 10:57 PM
Listing and limiting items from a database RPG SEARCH ASP.NET 1.0 and 1.1 Basics 11 August 3rd, 2004 04:37 PM
displaying items from a database?? Ashleek007 PHP Databases 3 April 27th, 2004 06:05 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.