Order by Variable inside query?

[D_tunisia]

I have a query which gets two dates from a table from which I work out the difference, but what I want to do, when I get the result of the difference, is to order the query results by the difference result.

Is there a way to do this?

[Houdini]

SELECT DATEDIFF('1997-12-31 23:59:59','1997-12-30');
//Prints 1

See MySQL Date and Time functions HERE

[D_tunisia]

Sorry, should have made it cleared what I wanted.

I want my query to go:

$result = mysql_query("SELECT * FROM table ORDER BY $difference");

while($myrow = mysql_fetch_array($result)) {

$date1 = $myrow[date1];
$date2 = $myrow[date2];

$difference = $date1 - $date2;

}

...but obviously that query is not possible in its current form, but is there a way to get the result that I want? I want to order the query results by a result that I get from the query!

[Blulagoon]

Maybe you could try the following, I think it might work:

SELECT DATEDIFF(col1,col2) as diff from mytable order by diff

where col1 and col2 are fields in the db.

Blu