Code: Select all
$result = mysql_query ("SELECT * FROM products WHERE pause = 'off' AND (preorder = 'yes' OR comingsoon = 'yes') ORDER BY preorder='yes' ASC");What I've tried, doesn't work. It's showing Comingsoon first.
Moderator: General Moderators
Code: Select all
$result = mysql_query ("SELECT * FROM products WHERE pause = 'off' AND (preorder = 'yes' OR comingsoon = 'yes') ORDER BY preorder='yes' ASC");Code: Select all
SELECT * FROM products WHERE pause = 'off' AND (preorder = 'yes' OR comingsoon = 'yes') ORDER BY preorder DESC, comingsoon DESC