[RESOLVED] Select whole row with link

[redshark]

Hello

I am making a form that user's data in stored in a MySQL db. There is then an admin page that lists all the ppl who have filled in the form and 4 of their pieces of data as a table. However, I would like there to be a link at the end of each row that allows the admin to see the individuals full answers that they supplied.

I imagine it is something like SELECT * FROM table (for this persons id); I'm just a little unsure of how to say that this link is for this person's id and the next link is for this person's id, and all without typing in WHERE id=13 etc. As it needs to be done automatically.

I know this is all completely wrong and I hope it makes some sort of sense, I have uploaded an example of what I am trying to do, if this post doesn't make much sense, to here

If you would like to me explain anything else then please let me know and I look forward to your responses and ideas.

Thanks in advance
Red

[bogu]

On that click here your link should be something like user_details.php?id=user_id
user_id will be the uniq ID of each person from your database ...

[redshark]

Thank you Bogu

It works an absolute treat apart from that if I have more than one person on the list the userInfo.php page shows all the info for all people on the list instead of for the single person that you clicked the link on.

<a href='userInfo.php?id=id'>click here</a> is the link I have at the minute, is there a way to make it recognise which person you are wanting to look at.

Thanks again
Red

[redshark]

Sorry I called this RESOLVED before I actually checked it properly, I have edited the previous post.