calling in from mysql, a bit more than that...

I'm creating a database with a lot of data inserted into them. These include first name, last name, an auto increment number, age, b'day, height etc.

I'm curious if I can just call in certain columns on one page, and if you click on that person's name, you can go to a page which will show that person's complete data.

I've done the first step, which calls in just the first and last name, but I want to click on the person's name and on a new page get all the detail of that person. I'm trying to avoid creating a seperate php file for each one to call in the data, I'm hoping that there is just one file i have to make which can take care of that.

hope i worded everything right..

thanks
umang :thumbsup:

I call in all the records in the table using a while loop..

while ($dbRow = mysql_fetch_object($dbResult))
{
print("$dbRow->nameLast" . ", " . "$dbRow->nameFirst <br>\n");

}

faqts.com had the solution.