crashmaster Posted September 30, 2008 Share Posted September 30, 2008 Hi there, I have portal with AD. Some AD's are normal, some of them are premium. I would like to know, how can I order my mysql_query : 1) Order by column PREMIUM (values "1|0"). At the begining will be shown PREMIUM ad's, than normal 2) Order by ID -> older ad's will be shown as the last.. Any ideas ?? Thx ! Link to comment https://forums.phpfreaks.com/topic/126379-double-ordering/ Share on other sites More sharing options...
discomatt Posted September 30, 2008 Share Posted September 30, 2008 ORDER BY `premium` DESC, `id` DESC Link to comment https://forums.phpfreaks.com/topic/126379-double-ordering/#findComment-653534 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.