Order results by count of that row

[prw]

I'm trying to make a function which will display the top X results of the row Y which I set, for this instance I'm using the row browser and the top 5 results from my table statistics, the where is just to eliminate Search Bot results from showing up. I also want it to return the count of the amount of rows as well. So say there was 10 results for the browser 'Safari', then it would return the count of 10 for that result as well as the result itself.

 

$display->show_list('statistics', 'browser', '5', 'WHERE browser!=\'Search Bot\'');

 

Here is my function. I'm cleaned it up a bit to remove certain checks and outputs if the query were to fail, etc.

 

function show_list($table, $row, $limit = 5, $where = NULL) {

$item = mysql_query("SELECT DISTINCT $row FROM $table $where LIMIT $limit");

            $result = array();

while ($fetch = mysql_fetch_array($item)) {

            $result[] = $fetch;
}
            return $result;
}

 

Basically, how would I go about making it count the amount of rows for the row I've set, and then to output that along side the result?