Re: sql statement - complex order by
| From: | Stut | Date: | Mon, 02 Jul 2007 19:47:32 +0000 |
| Subject: | Re: sql statement - complex order by | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-43732@lists.php.net to get a copy of this message | ||
Bryan wrote:
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? Thanks...select * from productgroup where groupid = $productid order by (label = 'Cats') desc, title And I do hope you're properly validating and escaping $productid. -Stut -- http://stut.net/