[RESOLVED] counting records

[scialom]

Hello,

I have a table with many ip address.
I would like to count how many time I have each ip address in my table.

Of course I can do this:
select distinct ip_address as unique_ip from tbl_ip

and then run through a loop
select count(ip) from tbl_ip where ip_address='$unique_ip'

but I don't like this solution. Is there another way to do it?

thanks!

[Bjom]

SELECT ip, COUNT(ip) FROM myTbl GROUP BY ip

[scialom]

thanks!