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']}";
}
}

Using ORDER BY in $query automatically sorts the results for you. if you want to have the results sorted by more than just the name, add the extra columns to it.

Example, ORDER BY name, date, city ASC