Assuming countorder is required, the following result was found.
array Display the first 10 rows of this array (if we are doing a top ten) My new method is: SELECT column1, COUNT(*) AS CountOrder FROM table1 GROUP BY column1 ORDER BY CountOrder DESC LIMIT 0,10 PHP script to loop through the results of the above query...