Help with a PHP Query.

Heres what I got. My sessions work properly...but when I do this query it doesnt bring back anything from my database. what I want it to do is bring back the firstname and the lasname of the logged in user.

PHP Code:

[size="2"] if ($logged_in == 1) {
    echo 'welcome back '.$_SESSION['username'].'';
 $query = sprintf("SELECT firstname, lastname FROM users WHERE '.$_SESSION['username'].'");


$result = mysql_query($query);
if (!$result) {
   $message  = 'Invalid query: ' . mysql_error() . "\n";
   $message .= 'Whole query: ' . $query;
   die($message);
}

while ($row = mysql_fetch_field($result)) {
   echo $row['firstname'];
   echo $row['lastname'];
}
mysql_free_result($result);[/size] 


[Cota]

missing part of your where claus...WHERE colum = value

[verdammte]

verdammte Schei! Thats all I have to say about that.Good work Coda,I can see you are gonna be a coda pimp around this forum house.

[Cota]

what can I say, I try

[iughk]

Looks like I’m going to have some competition. lol good job with the prompt reply Cota.

[Cota]

Trust me, PHP is not really my thing...but the problem was with the SQL..now we're talking database...

Lol, Thanks guys I got it figured. Ill be here more often for PHP problems. My deal is database and HTML not PHP. so Ill be back posting more problems. Thanks for the help guys.