query error...

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

« previous php.db (#16541) next »