In a query, why does $_SESSION[cid] work, but $_SESSION['cid'] not work?

[darp]

In this link quotes withing a global session array are clarified  http://www.phpfreaks.com/forums/mysql-help/%28solved%29-confused-as-to-what-quote-mark-to-use-in-a-query/

 

However I can't get $_SESSION['cid'] to work.

 

Could someone explain to me why this works:

 

$mysql = "UPDATE customer SET menulist = ' $menulist ', packlist = ' $packlist ' WHERE customer ='$_SESSION[cid]'";

     

mysql_query($mysql); 

           

Where as this does not.

 

$mysql = "UPDATE customer SET menulist = ' $menulist ', packlist = ' $packlist '  WHERE customer =" . $_SESSION['cid'];

     

mysql_query($mysql); 

 

What would the proper syntax/format be?

[PFMaBiSmAd]

The php parser needs a little help delimiting array variables when used in a string. If you put {} around $_SESSION['cid'] it will work without producing an error inside of a string.

[darp]

Thanks for the fast reply. This works. Do I have it right or can I improve on it?

 

$mysql = "UPDATE customer SET menulist = ' $menulist ', packlist = ' $packlist '  WHERE customer =  '{$_SESSION['cid']}'";

   

mysql_query($mysql);