ORDER BY 5s, then 3s, then 4s
Posted: Tue Nov 29, 2005 7:41 am
I have the following query which works fine.
However, I also want to order it by another column, item_type_id. This column (INT) contains integers between 1 and 5. I wish to run the query as above, then subsequently order by item_type_id with 5s first, then 3s, then 4s.
Any ideas or assistance? I'd be very grateful.
Simon
Code: Select all
$query = "select * from data_published where data_published.page_id = '$page_id' order by feature_order asc, data_published.time desc, data_published.feature_id asc LIMIT 27";Any ideas or assistance? I'd be very grateful.
Simon