Creating a link using the primary key

[barrowvian]

Hey, Im pretty new to php and have just been toying with a few ideas to get used to it.

 

So far I have created a basic database that contains 3 fields: userid, firstname and lastname. On one page I have echoed the firstname and lastname like so;

 echo $row['surname'] . ", " . $row['firstname'] ."<br />";

 

I want each row that is displayed to be a link to another page where other information will be presented based upon which user has been clicked.

 

(e.g) click on Smith, John and it will take you to his page with his information. How do I go about creating this so that the primary key can be used to identify which row has been clicked?

 

[jskywalker]

something like:

echo "<a href=moreinfo.php?$row['id']>".$row['surname'] . ", " . $row['firstname'] ."</a><br />";

 

where moreinfo.php gives more info about 'id'....

 

 

[ignace]

echo '<p><a href="profile.php?id=',$row['id'],'">',$row['surname'],' ',$row['firstname'],'</a></p>';

[barrowvian]

Thanks guys;

 

Tweeked it slightly to;

echo "<a href=profile.php?userid=$row[userid]>"

and it works fine. It initially didnt like the '' that surrounded the userid so thats where my problem was occurring. Thanks again! 

[ignace]

Try:

 

echo "<a href=\"profile.php?userid={$row['userid']}\">"

 

Also remember for valid HTML use " around values for attributes (href)

[barrowvian]

thanks ignace, works fine whilst maintaining valid HTML!

[jskywalker]

why could you not figure the answer out yourself, if you know about 'valid HTML'...?

 

(/me just curious)