linking with mysql

[backinblack]

I have a profile form the users fill out with name, city, address, etc... It goes into the database witch then I have a page that pulls out just there name. Where I a stuck at is how do you get it to have there name being a link now and goes to there profile? Some how there is going to be a whole new page made for there profile. I am new to this so I need a little help. Thanks.

[sde]

make a field in the database for a 'user_id'. set the field as an integer, auto-increment, and primary key.

this will make it so every new person will get assigned a new user id.

if you are using PHP, then you would make a page that gets the user info based of their userid. the URL might look like this: http://example.com/profile.php?id=234

so then, you could create a list of links to user profiles like this:

PHP Code:

<?
$result = mysql_query("select user_id, name from users");

while ($row = mysql_fetch_assoc($result)) {

  echo "<a href='http://example.com/profile.php?id={$row['user_id']}'>{$row['name']}</a><br />\n";
}
?>

on your profile.php page, you will need to query based off the $_GET['id'] variable.

$result = msyql_query("select * from users where user_id='" . mysql_real_escape_string($_GET['id']) . "'");