At 20:36 02/07/2007, you wrote:
Message-ID: <F4.81.24153.5C359864@xxxxxxxxxxxx>
To: php-db@xxxxxxxxxxxxx
Date: Mon, 02 Jul 2007 14:34:35 -0500
From: Bryan <bcotter@xxxxxxxxxxxxxxxxxxx>
SELECT * FROM productgroup WHERE groupid = $productid
AND label = 'Cats' ORDER BY title
SELECT * FROM productgroup WHERE groupid = $productid
AND label != 'Cats' ORDER BY label,title
I'd like to find a way to combine these 2 statements. I want to list
out all the products, ordered by title but listing out all the Cats
products first. Any way to do that without having separate statements?
See http://dev.mysql.com/doc/refman/5.0/en/union.html
(SELECT * FROM productgroup WHERE groupid = $productid
AND label = 'Cats' ORDER BY title)
UNION
(SELECT * FROM productgroup WHERE groupid = $productid
AND label != 'Cats' ORDER BY label,title)
HTH
Cheers - Neil
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
