Problem using a session in a query

[dprichard]

I have a query that is based on a session variable.  If I echo out the session variable, it works fine, but if I use it in a query it doesn't work.  Can you use a variable in a query like this?

 

$username = $_SESSION['MM_Username'];
$user = mysql_query("SELECT emp_id, emp_fname, emp_lname, emp_auth_level FROM employee WHERE emp_username = $username");
$row_user = mysql_fetch_array($user);

[Psycho]

You need to put single ticks around a string value when used in a query:

 

$username = $_SESSION['MM_Username'];
$user = mysql_query("SELECT emp_id, emp_fname, emp_lname, emp_auth_level FROM employee WHERE emp_username = '$username'");
$row_user = mysql_fetch_array($user);

[franknu]

your problem is at the end of the query

 

it should be something like this

 

WHERE  emp_username= ($_SESSION['username'])

[Yesideez]

hahaha here's a third method (which I use) just to confuse things...

 

$user = mysql_query("SELECT emp_id, emp_fname, emp_lname, emp_auth_level FROM employee WHERE emp_username = '".$username."'");

 

Although I prefer to use the user's ID number instead of the username.