[SOLVED] Displaying Profiles

[TGWSE_GY]

Okay we have the base of our site down, we can store the users profile information and recall it on the "update profile" page. Now my question is what is the best way to retrieve a users profile to display to another user?

 

 

Thanks

[The Little Guy]

Something like so:

 

http://mysite.com/profile.php?uid=38

 

if(isset($_GET['uid'])){
    $uid = mysql_real_escape_string($_GET['uid']);
}elseif(isset($_SESSION['id'])){
    $uid = mysql_real_escape_string($_SESSION['id']);
}else{
    header("Location: /");
    exit;
}
$sql = mysql_query("SELECT * FROM users WHERE id = '$uid'");
$row = mysql_fetch_array($sql);