I am sending a rather large UPDATE query to a table with a handful of sequential
fields (i.e. color1, color2, color3, size1, size2, size3, etc). The query is
generated and executed from within a PHP script, and to make the script more
efficient, the query is generated with a FOR loop, so that instead of updating the
fields in the order in which they exist in the table, they are updated according to
their number at the end of the field name.
So for example "UPDATE table SET color1='red', size1='big', color2='', size2='',
color3='', size3='' where id=1"
when i execute the query from the mysql shell, however, one row is matched but no
changes are made and warnings are returned.
My questions are:
a) does it matter what order you attempt to update the fields in?
b) is there a way to view what the warnings were?
many thanks if you can help me
marty mulligan
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
