Re: query error...
| From: | DL Neil | Date: | Tue, 05 Feb 2002 23:05:41 +0000 |
| Subject: | Re: query error... | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-16544@lists.php.net to get a copy of this message | ||
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