Now I have a table, where I know there are duplicate e-mail.
I would like something that echoes out all the duplicates and a number next to it telling me how many duplicates I have.

Like this:

12 abc@website.com
10 abc2@website.com
10 bill@website.com
9 janet@webiste.com
8 tom@internet.com
8 steve@sitepoint.com

and so on... showing me only the ones that have duplicates and the top one first.

What I have now is just showing me the top one, so I guess there only have to be a modification of the following:

PHP Code:
$result mysql_query("SELECT email, COUNT(email) AS countemail FROM temp_db GROUP BY email ORDER BY countemail DESC LIMIT 1");
 
$row mysql_fetch_assoc($result);


echo 
"<p>The most duplicated email is " $row['email'] . "</p>"