[PHP] Having Trouble With Session Variable in Query Statement

2009-02-23 Thread revDAVE
Hi folks, I'm trying to make an update query with a session variable... It creates this error: Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in ... Q: the session var shows ok on the page : ID ?php echo $_SESSION['now_poid'];

Re: [PHP] Having Trouble With Session Variable in Query Statement

2009-02-23 Thread Paul M Foster
On Mon, Feb 23, 2009 at 12:34:58PM -0800, revDAVE wrote: Hi folks, I'm trying to make an update query with a session variable... It creates this error: Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in ... Q: the

Re: [PHP] Having Trouble With Session Variable in Query Statement

2009-02-23 Thread Philip Graham
On February 23, 2009 15:34:58 revDAVE wrote: Hi folks, //but this does not.. $updateSQL =UPDATE `mytable` SET thetotal=$amt WHERE id=$_SESSION['thisid']; Q: How can I fix it? try : $updateSQL =UPDATE `mytable` SET thetotal=$amt WHERE id={$_SESSION['thisid']}; or even better:

Re: [PHP] Having Trouble With Session Variable in Query Statement

2009-02-23 Thread revDAVE
On 2/23/2009 12:44 PM, Paul M Foster pa...@quillandmouse.com wrote: Don't single quote values inside array brackets when the whole expression is in double quotes. You've got: ... $_SESSION['thisid']; Do this instead: ... $_SESSION[thisid]; AHA - thanks much - that worked! --

Re: [PHP] Having Trouble With Session Variable in Query Statement

2009-02-23 Thread Micah Gersten
Paul M Foster wrote: On Mon, Feb 23, 2009 at 12:34:58PM -0800, revDAVE wrote: Hi folks, I'm trying to make an update query with a session variable... It creates this error: Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or