Linked list

[Anon]

I have a page where I display some information in columns like:

Firstname
Surname
Dateofbirth
Age

And for each person I have more information in a database, how can I make a link to that information.

For example, if I have ROBERT on the first row: I want a linkfrom ROBERT to a standart page where ALL information about robert is displayed...

How could I do that.... I'm using a MySQL database...

[Anon]

Your link would be something like
<a href="info.php?name=Robert">More Info</a>

or if database driven

print ("<a href=\"info.php3?name=$Firstname\">More info</a>");

Then on your page "info.php3" you would do another select statement but using Roberts name to find the rest of the data like:

mysql_query(SELECT * FROM $dbtable WHERE Firstname = '$name');

while($row = mysql_fetch_array($sql))
{
print ("$row[Surname] $row[Dateofbirth] etc");
}

scott d~