[SOLVED] Problem Using Session Variable In Query String

[stevesimo]

Hi, I am attempting to pull out a record where the ID of the order is equal to the value contained in a session variable called policyRef.

 

I keep getting a parse error so am not sure what I am doing wrong.  Here is the offending line of code:

 

  $certificate = mysql_query("SELECT * from orders where PolicyID=".$_SESSION['policyRef']"");

 

Any help appreciated.

 

Thanks, Steve (Blackpool)

[kenrbnsn]

You have too many quotes at the end of the string. You probably want:

<?php
$certificate = mysql_query("SELECT * from orders where PolicyID=".$_SESSION['policyRef']);
?>

or

<?php
$certificate = mysql_query("SELECT * from orders where PolicyID='".$_SESSION['policyRef'] . "'");
?>

 

Ken

 

[stevesimo]

Hi Ken, that code worked for me!  thanks for your help m8.

 

Steve (Blackpool)