sort array

[kimi]

Hi..

This is my code.

$query = "SELECT sports_house , COUNT(*) AS sum  

                 FROM student GROUP BY sports_house";
$result = pg_exec($result);                   

while ($get = pg_fetch_array($result)) { 
       $arrs[] = $get["sports_house"]; 
       $arr2[] = $get["sum"]; 
} 

The result will be like this
Blue : 3
Green : 2
Red : 3

So now i want to sort this array so that Green will be the first in row.
How to do this?
Thanks.

[Weedpacket]

Why do you want Green to be the first? Because it's count is lower? Put an "ORDER BY sum" clause in your query and it'll be sorted when PHP receives it.

For any more elaborate conditions, PHP's usort() function could be used.