Having Trouble With Session Variable in Query Statement

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']"; Q: How can I fix it? -- Thanks - RevDave Cool @ hosting4days . com [db-lists 09]