query error...
| From: | jas | Date: | Thu, 31 Jan 2002 09:43:48 +0000 |
| Subject: | query error... | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-16541@lists.php.net to get a copy of this message | ||
Ok what is wrong with this sql statement?
$sql = "UPDATE $table_name SET
c_name=\"$c_name\",s_addy=\"$s_addy\",city=\"$city\",state=\"state\"zip=\"zi
p\",phone="\$phone\"";
The error I recieve is as follows
Warning: Unexpected character in input: '\' (ASCII=92) state=1 in
/path/to/wwwdemo_change.php3 on line 22
Parse error: parse error in /path/to/wwwdemo_change.php3 on line 22
I have looked on MySQL.com at the update function and it states I can use
the SET under UPDATE for multiple fields separated by a , and it is not
working... Any insight would be great.
Thanks in advance,
Jas