I'm trying to sort a mysql query by 2 conditions: Deadline in future or deadline in past.
The table has a column named 'deadline'. When outputting the result i would like to first show all the deadlines in the future with the nearest first, when all these are outputted, the ones with a deadline in the past should be outputted, with the most recently 'expired' at the top.
Like this, with today being 7 July 2012:
14 July 2012
18 July 2012
05 July 2012
01 July 2012
the results are paginated, so i would like to be able to achieve this with 1 query if that is possible..