Mysql - Count Distinct Ip Addresses For A Date Range

Title: Mysql - Count Distinct Ip Addresses For A Date Range
Source: ScriptLance
Category: MySQL
Posted On: Sun, 5 Feb 2012 00:02:50 GMT
Description:
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.
 
Share This Job:
Freelance Jobs

Recently Posted Projects:
Project Title Share
php programming
pay per article: $5.5
page template filter by dynamic taxonomy term (genesis FW)
need some pp , no skills,no past work required
need off page optimization
magmito.com similar site and service
Web Search on VAUKT DOORS for a bank
WEB SCRAPING / MINING GOOGKE KEYWORD TOOK
Unity3d / iOS / C#
Technical translation form English into ARABIC - chandelier
Sub Categories & Product Kisting Display
Strong PHP programmers wanted for a long term basis
Small Html Coding Project
Simple Wordpress Plugin
Serious eBay, Amazon, ioffer or any other selling local site