Sort and count mysql results...?

programming
1

Hi, how would I sort the results after the number of “mysql_num_rows” in the following query:

$sql= mysql_query("SELECT url, count( * ) AS count FROM `stats` GROUP BY `url`");
while($r=mysql_fetch_assoc($sql)) {   
  $query = mysql_query("SELECT url FROM `stats` WHERE `url` = '$r'") or die(mysql_error());
  $new_id = $r['url']." (".mysql_num_rows($query).")<br>";
  echo $new_id;

I would like to have something like this:

url1 (10)
url3 (8)
url2 (4)

Regards,
Vero