[SOLVED] Getting top 10?

[Chevy]

I am trying to get the top 10 rows out of a table in MySQL.

 

The thing is I want the top 10 rows of usernames...

 

  $stuff = mysql_query("SELECT MAX(`username`) AS `username` FROM `stuff` LIMIT 10");

     while ($top = mysql_fetch_array($stuff)){

          echo '<hr>'.$top['username'].'<hr>';

      }

 

So if there were 4 rows with the same username i would be above the one with  rows of one username.

 

Make sense?

[Barand]

There can only be one MAX(username) so only one row will be returned by that query.

 

SELECT username, COUNT(*) as total 
FROM stuff 
GROUP BY username
ORDER BY total DESC 
LIMIT 10

[Chevy]

Thanks a ton