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