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-stat

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 >> the

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

2005-04-18 Thread Gustav Wiberg
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: IDCate