Quick query question

say if i wanted to get the current session users username from my myql database, what is the easyest/shortest/proper way of doing this

The only way i know of is putting it into an array like so, which seems quite pointless for one single field.

$result=mysql_query("select * from users where username='$_SESSION[username]'");

$get_email=mysql_fetch_array($result);

echo $get_email[email];

Jonno

If you want to hold it in a single var instead of an array, you can just do:

$result=mysql_query("select email from users where username = '$_SESSION[username]'");

$get_email=mysql_fetch_row($result);

$user_email = $get_email[0];