A better way to show user information?

[Artsybetty]

whats the best way to set session variables from db?

 

i'm kinda new to this, so im just checking the session variable "uid" against the users id in the db, and if true, posting something, should i be doing this totally different? any help is apreciated

 

$result = mysql_query("SELECT * FROM `users` WHERE `id`='".$_SESSION["uid"]."' LIMIT 1");
while($row = mysql_fetch_array($result))
{
echo $row['username'];
echo $row['id'];
}

[Barand]

// define query in a string first, it makes debugging easier if there's an error

// don't use *, define the columns to be selected

$sql = "SELECT id, username FROM `users` WHERE `id`='{$_SESSION["uid"]}' LIMIT 1";

$result = mysql_query($sql);


// you don't need a while loop for a single row

if ($row = mysql_fetch_array($result))

{

    echo $row['username'];

    echo $row['id'];

}

[Artsybetty]

cheers barand.