counting duplicate entries

[Guest_imported]

I have a simple mysql database of visitors to a web site. Table fields are IP address and date. Is there a way I can get a report of how many times each ip address has visited my site. Of course I don't need to see those ip addresses who only show up once. Basically I want a report of the number of times a field contains duplicate data. If the IP address of 192.168.1.1 hits my web site twice I want the report to show

192.168.1.1 2

Hope this make sense Thanks in advance for any help.

 

[scubaray]

Use a SQL Statement like this:

select ip_addr,
count(*)
from myipvisitors
group by ip_addr
having count(*) > 1;


HTH

 

[Guest_imported]

GREAT!! Thanks....I really need to brush up on sql...Thanks a million!!