note 24080 deleted from function.array-multisort by aidan

Note Submitter: jpirkey at email dot com ---- To: salim@codesplash.com Another option is to modify the SQL statement and not use the array_multisort function. MySQL supports the ORDER BY clause. For instance: //Get table sorted on field2 output into $result1 and $result2 array <?php // ascending order by field2 $result1 = mysql_query("SELECT field1, field2 FROM table ORDER BY field2"); // descending order by field2 $result2 = mysql_query("SELECT field1, field2 FROM table ORDER BY field2 DESC"); ?> Note: I have not benchmarking to determine whether PHP is faster in sorting or MySQL. It would be worth some investigation if you are using large tables. Hope this helps.