Ok jas > 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\"";
insufficient checking: comma missing between state and zip " incorrectly escaped before phone ... > 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. Insight: use ECHO to output $sql to the screen. If the results are less than satisfactory, copy-paste the sql code into native MySQL or a management package, the errmsgs are usually more informative/directive. Regards, =dn -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php