select id in mysql

[ramram]

Hey guys,

I have three fields in mysql. First one is id which is auto increment. second one is the first name and last field is last name.


I want to display only one field at the time in php how can I just show id number 5 in a specific page?

[Psycho]

Only one field or only one record? A field would be "firstname", a record would be all fields for a single "row" in the database - in other words, id, firstname & lastname for one person.

You can get a single record like this (assuming the ID field is uniqe):

SELECT * FROM [i]tablename[/i] WHERE id  = '[i]idnumber[/i]'

[ramram]

thanks.