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 Jo

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

[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