RE: [PHP] Single SQL-statement in PHP to order...

[Jared Williams]

  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

Re: [PHP] Single SQL-statement in PHP to order...

[Richard Lynch]

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