Re: [PHP] Help with UPDATE command...
Hi Tony, > The UPDATE command does not seem to support > the ORDER BY part despite it being listed in the > instructions on the mysql.com website. This is only supported in versions 4 and above - if you're using 3.23 you can get away with LIMIT in your update queries, but not ORDER BY. Cheers Jon -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Help with UPDATE command...
what error message are you getting? mysql_error() and mysql_errno() Tony Tzankoff wrote: Here is the code I am trying to implement... update table set col1=value where condition=true and condition=true order by col2 desc, col3 desc limit 1; The UPDATE command does not seem to support the ORDER BY part despite it being listed in the instructions on the mysql.com website. Is there any workaround to this that anybody knows of? Thanks in advance for your help. :o) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Help with UPDATE command...
Here is the code I am trying to implement... update table set col1=value where condition=true and condition=true order by col2 desc, col3 desc limit 1; The UPDATE command does not seem to support the ORDER BY part despite it being listed in the instructions on the mysql.com website. Is there any workaround to this that anybody knows of? Thanks in advance for your help. :o) -- Tony Tzankoff http://www.tzankoff.com = -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php