[SOLVED] How to ... count total instances of a record and then sort the records ?

[adrianTNT]

I got stuck at something that I thought it was simple 

 

I have this code:

do { 
echo $row_Recordset_count_referers['referer_url'];
} while ($row_Recordset_count_referers = mysql_fetch_assoc($Recordset_count_referers)); 

 

That block will return site referers form database like this:

some_site.com

some_site.com

some_other_site.com

some_other_site.com

some_other_site.com

 

How can I display each unique record and total instances next to it (sorted descending)?

so that it looks like this:

 

site.com (4);

other_site.com(2)

foo_site(1)

 

Can someone provide a code block? Or at least Instructions?

Thank you.

[Wuhtzu]

It is quite simple

 

<?php

$getreferrers = mysql_query("SELECT referrer, COUNT(referrer) AS count FROM products GROUP BY referrer ORDER BY count DESC");

?>

 

This will allow  you to do

 

<?php


while($row = mysql_fetch_array($getreferrers)) {

    echo $row['referrer'] . "(" . $row['count'] . ")";

}

?>

[adrianTNT]

Thank you Wuhtzu I adjusted row names a bit and the code worked nicely.

Have a great day.

[Wuhtzu]

Since you did not give any field names I had to make them up, but I'm glad to hear it worked