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 session var shows ok on the page :
> ID <?php echo $_SESSION['now_poid']; ?>
> - so how do I fix the error?
>
> ==========================================
>
> <?php require_once('../Connections/dblink.php');
> if(!session_id()) session_start();
> $amt = 18;
> $id1 = 8;
> $_SESSION['thisid']=8;
> $id2 = $_SESSION['thisid'] ;
>
>
> //these 3 work
> $updateSQL ="UPDATE `mytable` SET thetotal=$amt WHERE id=8";
> $updateSQL ="UPDATE `mytable` SET thetotal=$amt WHERE id=$id1";
> $updateSQL ="UPDATE `mytable` SET thetotal=$amt WHERE id=$id2"; // uses
> $_SESSION['thisid']
>
> //but this does not..
> $updateSQL ="UPDATE `mytable` SET thetotal=$amt WHERE
> id=$_SESSION['thisid']";
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]";
Paul
--
Paul M. Foster
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
