select ... from ... ORDER BY (IDCategory = 4) DESC, IDCategory = 4 will return 1 or 0, for 4 or not 4. 1 is bigger than 0, in most countries. :-) On Mon, April 18, 2005 2:50 pm, Gustav Wiberg said: >> Hi there! >> >> I guess this is off-topic? but I want to know if this is possible. (If >> there's anyone out there that have a solution, I would appreciate it >> though) >> >> I want to know if there is anyway of showing tables in PHP in an order >> like this in a single SQL-statement... >> >> Table is like this: >> IDCategory >> 7 >> 15 >> 4 >> 3 >> >> I want to order the table like this: First everything that is IDCategory >> 4, then the rest of the posts (doesn't matter which order) >> >> /G >> @varupiraten.se >> > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- Like Music? http://l-i-e.com/artists.htm -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
