Query Using Session ID

[Andy Benham]

Hi all,

Sorry I'm very new to this,

I want to do something I thought would be quite simple, that is I want to pull the users real name (first and last) from my database when they login.

The login system I am using sets up the 'username' as the session ID, which is presented in the php as $_SESSION['user']

Using mySQLi I imagined I could do something like this:



////PHP///

$_SESSSION['username'] = $username;

$result = $db->query("SELECT `firstname`, `lastname` FROM `members` WHERE username='$username'") or die($db->error);

if($result->num_rows){

$rows = $result->fetch_assoc();

}
///

Then pull it from the array and just insert it in to the site header, however I can return this in any permutation I try.

Anybody point to what I'm doing wrong?