|
Posted by Arjen on 04/13/06 13:32
Dejan wrote:
> 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..
SELECT COUNT (id) GROUP BY name
Arjen
Navigation:
[Reply to this message]
|