sorting selected data

[aluviana]

hello,

I have a script that retrieves data from a database. Now I want to sort these informations by name, date etc... So, the question is how can i sort already selected data?

tnx

my script for selecting:

 
$query  = "SELECT name, user, city, date from USERS order by name ASC";
$result = mysql_query($query);

if (mysql_num_rows($result) < 1){

   echo "No results";

   } else { 
           while($row = mysql_fetch_array($result, MYSQL_ASSOC)) {

         echo "{$row['name']}";
         echo "{$row['user']}";

         }
      }

[examancer]

you can use sort(), or for this particular case, usort() combined with a custom user sort function so you can tell it exactly how to sort. Its really not as hard as it sound if you read through the documentation on usort().

basically you'll want to combine all your records into a single array, and then use usort() and your own sort function on the array.