Page is a not externally linkable
- Code, Content, and Presentation
-- Databases
---- Ordering twice with group by

syber - 7:19 pm on Sep 5, 2010 (gmt 0)


"adding title doesn't seem to change the order"

Looking at your example you probably want the order by to be:

ORDER BY inventory_code, title, variation_number DESC

Thread source:: http://www.webmasterworld.com/databases_sql_mysql/4196799.htm
Brought to you by WebmasterWorld: http://www.webmasterworld.com