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

2005-04-19 Thread 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...

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

2005-04-18 Thread 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