Did you type this out or cut/paste? There was a comma missing between >>> state"\"zip <<<. Should work when you add the comma.
Add a WHERE condition for the update, otherwise every row will be set to these values. Common practice is to use single quotes around the char variables, saves a lot of escaping, keeps things more readable. In connection with this, echoing $sql would probably have revealed the missing comma, and don't feel badly, we've all done it. Hope this sees you right - Miles At 02:43 AM 1/31/2002 -0700, jas wrote: >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 > > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php