MySql order by COUNT and list the total count
===

I am using this code to count and sort from my database:

    $qry = "select entertainer, count(*) from final_results group by entertainer order by count(*) desc";

I get the right result, in as much as it lists all the contents in order or popularity.

What I would like is the top 5 results to display, with a count for each of them and then a total count of all the results.

e.g.

> Top response (10) <br>
Second response (8) <br>
Third response (6) <br>
etc... <br><br>
Total count = 56

I would appreciate any help and advice.

Thanks,

John C




