Page 1 of 1

Can I Order by two fields, so it shows order by one first?

Posted: Fri Aug 29, 2014 8:44 am
by simonmlewis

Code: Select all

$result = mysql_query ("SELECT * FROM products WHERE pause = 'off' AND (preorder = 'yes' OR comingsoon = 'yes') ORDER BY preorder='yes' ASC");
I need to show all those that are "preorder='yes'" first, and show comingsoon = 'yes' after.

What I've tried, doesn't work. It's showing Comingsoon first.

Re: Can I Order by two fields, so it shows order by one firs

Posted: Fri Aug 29, 2014 8:50 am
by Celauran
Maybe this?

Code: Select all

SELECT * FROM products WHERE pause = 'off' AND (preorder = 'yes' OR comingsoon = 'yes') ORDER BY preorder DESC, comingsoon DESC

Re: Can I Order by two fields, so it shows order by one firs

Posted: Fri Aug 29, 2014 8:57 am
by simonmlewis
Ahh that's it, thanks.