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 


PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to