How to sort a query result array

Question

Hi, I have a array with results from a query from regular tables, for example:

id | Name | Department | Location | Email | Phone | Type | ..........and so on

I have the results in a query array, I can get the default query sorted, but I would like to ability to be able to resort that array as needed without having to keep re-reading data from the server, to cut down on traffic / speed things up.

Is there a native function that does that so I can go like:

sort(array by department ascending)
display array in nice format

Any ideas?

Answer 1

You can sort it this way (since it is an associative array):

function cmp($a, $b)
{
   return strcmp($a['department'], $b['department']);
}

usort($your_array, "cmp")
print_r($your_array);

Answer 2

You can use array_multisort(), though you need some more processing as per your requirements.

Have a look at it http://www.phpf1.com/manual/array-multisort.html