View Full Version : Converting results into a link

02-05-2007, 10:09 PM
Hello All. Any help here would be appreciated.

I have created a MySQL DB and I am doing well developing it. The customer threw me a curveball that I can't seem to figure out.....

The database is somewhat of a family site that family members can go to and register with a questionaire. When they fill out the questionaire they are thanked and then brought to a page where all the first and last names of the people that registered are listed.

The first column in the table is name. The customer would like to be able to click on any of the displayed names in the list and it would bring them to a page showing all the answers of the questionaire.

My question is how do I display all the names in the column and then link them to thier respective row when clicked. Is there a way to create a link out of each of the results?

For example.....

Tom Smith <-----------when clicked would show a page with all his details

Thanks in advance.....


02-06-2007, 02:20 AM
I believe what you are looking for is commonly referred to as a Master/Detail page. The Master page being the one with the linked names gives general basic information about several different records. And the Details page being the a more in depth page with specifics about a particular record. Although, this will require a MySQL DB this question is better suited for the PHP forum. Alternatively, you can search either here in the forum or you can GOOGLEPHP master-detail tutorials (http://www.google.com/search?q=PHP+Master%2FDetail+Tutorial&hl=en).