Hi,
I am having trouble updating a record in MySQL.
Below are several different methods I have tried to use. The problem seems to be in the WHERE part, for when the query appears on multiple lines, the error message points to the line with the WHERE statement.
Here are some of the ways I have tried:
PHP Code:
$dbQuery = "UPDATE tbluser SET usrTplID=$_SESSION[tplid], usrTplName='$_SESSION[tplname]' ";
$dbQuery .= "WHERE usrUsername='$_SESSION['user']';";
mysql_query($dbQuery);
PHP Code:
mysql_query("UPDATE tbluser SET usrTplID='$_SESSION[tplid]' WHERE usrUsername='$_SESSION['user']' AND usrPassword='$_SESSION['pass']' AND usrSiteName='$_SESSION['site']'") OR die;
PHP Code:
mysql_query("UPDATE tbluser SET usrTplID=$_POST['rbtTemplate'] WHERE usrUsername=$_SESSION['user'] AND usrPassword=$_SESSION['pass'] AND usrSiteName=$_SESSION['site']");
PHP Code:
mysql_query("UPDATE tbluser SET usrTplName='$_SESSION[tplname]', usrTplID='$_SESSION[tplid]' WHERE usrUsername='$_SESSION['user']' AND usrPassword='$_SESSION['pass']' AND usrSiteName='$_SESSION['site']'");
PHP Code:
mysql_query("UPDATE tbluser SET usrTplName='$_POST['hfTplName']', usrTplID='$_POST['rbtTemplate']' WHERE usrUsername='$_SESSION['user']' AND usrPassword='$_SESSION['pass']' AND usrSiteName='$_SESSION['site']'");
The error message I receive is:
Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in step1update.php on line 19
(line 19 in this case is
$dbQuery .= "WHERE usrUsername='$_SESSION['user']';"
So, I have tried updating only one field, or putting only one condition in the WHERE statement, but it makes no difference...
The error message of of no help either: when I look it up in the PHP manual there's no reference for any of them; just the T_VARIABLE has a reference but is of no help.
I'm stuck... Anyone has any ideas?
Thanks for your help,
Toine
Dev Articles Community Forums Sponsor:
November 22nd, 2003, 08:18 AM
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
