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?

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!

Hi,

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

jan

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