Sorting an sql query array

[scott.timlock]

$sql = "SELECT invoice_id, vehicle_id, type, date FROM invoice_haul WHERE date > ".$time;
if ( !($result = $db->sql_query($sql)) )
{
die('Error in obtaining haul data');
}
while($haul = $db->sql_fetchrow($result))
{
$row[] = $haul;
}

 

I cannot for the life of me figure out how to sort $row by the key $row[]['date'].... i know i can just ORDER BY the sql query but there are other queries that add to $row and i need to sort by the date after the fact.

[khr2003]

check out these php array sorting functions:

http://www.php.net/manual/en/array.sorting.php

 

I think you will need to use ksort() or krsort() depndes on what you need to accomplish