[SOLVED] Query a session variable?

[elis]

I need to perform a mysql query with a variable stored in a session - so far, it hasn't worked. It's not something I've ever needed to do before so I'm not sure what I'm doing incorrectly. (the session syntax is different due to the variant coding used)

 

Below is a brief snippet of what I used.

<?php
$username = $session->get('s_username');
$sql = "SELECT * FROM employees where username =  $username";
?>

 

 

[DeanWhitehouse]

your query is wrong, use

 or die(mysql_error());

to find these things out, it should be

$sql = "SELECT * FROM employees where username =  '$username'";

or

$sql = "SELECT * FROM employees where username =  '".$username."'";

[premiso]

<?php
$username = $session->get('s_username');
$sql = "SELECT * FROM employees where username =  '$username'";
?>

 

Assuming your session class works, you need single quotes around the variable when checking against mysql.

[elis]

I see, that fixed it. Thanks for the help.