# Sort and count mysql results...?

**URL:** <https://forum.kirupa.com/t/sort-and-count-mysql-results/252744>\
**Category:** programming\
**Created:** [February 23, 2008, 12:37am UTC](https://forum.kirupa.com/t/sort-and-count-mysql-results/252744 "2008-02-23T00:37:59Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![veroaero](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/veroaero/32/3681_2.png) [@veroaero](https://forum.kirupa.com/u/veroaero)\
**Post date:** [February 23, 2008, 12:37am UTC](https://forum.kirupa.com/t/sort-and-count-mysql-results/252744/1 "2008-02-23T00:37:59Z")

</div>

Hi, how would I sort the results after the number of “mysql\_num\_rows” in the following query:

```auto
$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