damn select/order by query

[drewbie]

hey guys im trying to order by the field that has 'none' in the unique_id field for a group of CID's, then sort the rest by date_time ASC, ive read some close threads but i cant seem to get it to work, i either get an error from mysql or some other type of sorting occurs that isnt affected when changing ASC to DESC, wierd. anyways, here's what i have-

"SELECT CCID, AID, comment, unique_id FROM comments_calls WHERE CID='$result[CID]' AND hidden='0' order by case when unique_id = 'none' then date_time end ASC"

thanks for any help, oh and the reason i needed to sort them is because i want to indent all the non-'none' rows. thanks again!

[tomhath]

You want the 'none' rows first, then the other rows. Within each group the rows are sorted by date_time?

order by
case when unique_id = 'none' then 0 else 1 end ASC,
date_time ASC

[drewbie]

thanks! so it is possible to learn something every day...