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_VARI

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" 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! -- Thanks - RevDav

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 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

[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 - so how do I fix the error? ===