RE: [PHP] Single SQL-statement in PHP to order...
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) SELECT *, 1 AS sequence FROM Table WHERE IDCategory = 4 UNION SELECT *, 2 AS sequence FROM Table WHERE IDCategory != 4 ORDER BY sequence ASC Jared -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Single SQL-statement in PHP to order...
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
Re: [PHP] Single SQL-statement in PHP to order...
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