Duplicates

Hi

First sorry for my terreble english

I have mysql table like this:

id | name
---------------------
1 | Ivan
2 | John
3 | John

Now i wanna display it on web page like this

Ivan (1)
John (2)

Selecting duplicates, buth only showing number of duplicates..
How to do that?
tnx in advance
Dejan
dejan [ Mi, 12 April 2006 12:08 ] [ ID #1273212 ]
PHP » alt.php.sql » Duplicates

Vorheriges Thema: Generating a CDR file using PHP scripts.
Nächstes Thema: Wanted: db of biz cats