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
