User Submitted stats on page...

[Virtue]

I seem to have a barrage of questions lately. Hehe. I apologise if I am annoying anyone.

I have created a system (not a membership system) that has a user filling in a form with his/her statistics.
Now, when the user clicks submit, their info is added to my database and their name appears on one of the other pages (User List). What I want to know how to do is make it so that a user can click on his/her name (or any other name for that matter) and be taken to a page that will display the stats that they entered on the form.

Now, I know how to code the stats page, all I really need to know is how to turn the name into a link that when clicked on, will display a page containing that specific Users stats.

Can anyone help me?

I am more than willing to paste the Code I have used in here if need be.

Thank you for reading, and for any help you may be able to provide.

• Virtue.

[slick]

I'm assuming that you have a unique reference of some sort for each user that submits their stats (e.g. username or auto_increment id). If so, in the script that lists the users, make each link something like:
<a href="viewuser.php?id=$userID">$userFirstName $userLastName</a>

Then, in viewuser.php, grab the id (it will be $id) and use it to fetch the user stats from your database table.

Hope that helps,
Slick