Mysql – Count Distinct Ip Addresses For A Date Range


Post a Project Like This

Hi,

I am looking for some help to create a mysql query to get the distinct (per day) count of ip addresses a link has been clicked for a date range.

Lets say my IP address clicks on the same link 5 times every day during January 2012 using the same ip address. There would be 155 (5*31) records in the table but the query result should display 31 as we are only counting the same ip address max of once per day.

Yes, I would like to prepare this project. Let me place my bid ! (new window)
Posted Under: Uncategorized
This post was written on February 4, 2012   
Tags: , , , , , , , ,
Add to Favorites Add to Favorites
Hide project Hide project
Hide and Report to Administrator Hide and Report to Administrator
Guaranteed result or your money back

Comments are closed.

Next Post:
Previose Post: