Selecting duplicate entries using mysql?

[strange1]

I'm having the following problem:

Let's assume I have a table with 3 fields: ID (type int), NAME(type varchar), EMAIL (type varchar) in a mysql db.

The fields have the following data stored:

1, jack, [e-mail]
2, tom, [e-mail]
3, jack, [e-mail]
.
.
.
.
2000, jack, [e-mail]

Now let's say I have like some thousand entries like that one above with each one containing different data. So if there are entries which have the same email adress, how I can I select exclusively those entries with the duplicate data in it?

So the result of a selection should look something like this:
(If I want to show the selection results in html):

<table>
  <tr>
    <td>First matching duplicate entry.</td>
    <td>Second matching duplicate entry.</</td>
  </tr>
  <tr>
    <td>1, jack, [email][e-mail][/email]</td>
    <td>2, tom, [email][e-mail][/email]</td>
  </tr>
</table>

what does the php code have to look alike?

[Traduim]

SELECT field1,count(field1) from table group by field1 having count(field1) > 1

This would output something like

jack,3
john,5
peter,2

Meaning, there ara 3 Jacks, 5 Johns and 2 Peters.

Of course, you could select and filter using more fields, where and order by clauses.

[strange1]

that's cool, hmm, actually I did this:

<?
    require('dbconnect.php');
    $query = "SELECT email,count(email) from table group by email having count(email) > 1";
    $result = mysql_query($query);

 while($row = mysql_fetch_object($result))
 {
   echo $row->email;
 }

 mysql_close();
?>

it's just showing me the duplicate emails, how do I get both rows where the emails are the same?