Using $_session in mysql SELECT

[perficut]

I cant seem to figure out the right syntax for doing this.

 

If I use the following it displays the users name which was passed into this file from another php file.

echo $_SESSION[ 'u_name'];

 

I want to open my database and get the rest of the users info based on the users name.  Heres what I have, that obviously doesnt work.

 

$userdata = mysql_query("SELECT * FROM ILContractors WHERE username=$_SESSION['u_name']") or die(mysql_error());
$userinfo = mysql_fetch_array( $userdata );

[PFMaBiSmAd]

String data in a query must be enclosed in single-quotes and because the php parser needs help dealing with array variables in a string you need to put {} around array variables -

 

$userdata = mysql_query("SELECT * FROM ILContractors WHERE username='{$_SESSION['u_name']}'") or die(mysql_error());