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.