session variable help

[imarockstar]

I am trying to pull data from the db using this statement ...

 

(line 44 reads )

$result = mysql_query("select * from jobs where recid = '. $_SESSION['recid']' ");

 

 

this is my error :

 

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/franklin/public_html/sites/dwf/admin_jobs_view.php on line 44

[lemmin]

It should be like this:

$result = mysql_query("select * from jobs where recid = ". $_SESSION['recid']);

[BlueSkyIS]

best to single-quote ALL values (numeric and string) in MySQL. i would do this:

 

$result = mysql_query("select * from jobs where recid = '{$_SESSION['recid']}'") or die(mysql_error());

[imarockstar]

thanks that fixed it

[lemmin]

best to single-quote ALL values (numeric and string) in MySQL. i would do this:

 

$result = mysql_query("select * from jobs where recid = '{$_SESSION['recid']}'") or die(mysql_error());

Why would you ever want a numeric value in single quotes?