Mysql - Count Distinct Ip Addresses For A Date Range

Freelance Project Resource

Published: 5th Feb 2012

Project Viewed: 46 times
Filed in: MySQL

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 ...

Mysql - Count Distinct Ip Addresses For A Date Range freelance project is offered at scriptlance. You will need to have Coder account before you place your bid. If interested, you can get your scriptlance account. In case you already have an account with scriptlance, You can check Projects Details and Apply for Mysql - Count Distinct Ip Addresses For A Date Range Freelance Project.

Related Freelance Projects

• Php, Mysql, Symfony site needs CRUD changes + database creat I have a working website. It has been done with Symfony using apostrophe as the API. The site has some minor bugs and I also want a few minor graphics removed (nothing more needs to be designed, for now...) I want to change the CRUD.. ...

• Website developer php mysql opencart css html looking for a website developer that can do going work for our website. We use opencart, php, mysql, javascript, css. We need someone who is very knowledgeable in these coding languages and who can work a few hours a week on an ongoing basis.. ...

• Create Date Picker W/ Admin Panel To Designate Avail Dates This date picker is on a web form. It must do the following. 1. Allow an admin to designate which dates and spans are available for appointments in the calendar for an entire year. Examine the attached PDF to see a sample admin panel that provides the flexibly to block specific dates and times o ...

• Php Mysql Plug Script Need a plug script where I input a title, description, url, and upload an image to a database from an admin page. Would like to have the login integrated into current admin. Would like an output I can place on webpages where I specify the number of plugs to show, and how they will be displayed. T ...

• Java, MySQL developer Looking for a very experienced Java, MySQL developer for an exciting and challenging project. We are building a search and analytics web tool that incorporates multiple very large databases and advanced search capabilities.. ...

• Php Mysql Code Generator To Create Custom Web Applications I want a php & mysql automated code generator web application in which anyone who does not know programming can also create customized database centric php web applications which can be run online and offline also with help of wamp/xampp. For example you can see or (user type : Data entry use ...

• Mailing Blacklist Monitor that can check range of IPs I know the project name was quite vague, sort of hard to explain but, here is what I need. I need some kind of script, whether it be in perl that can be done via console in Linux or some kind of.. ...

• php, mysql code generator to create custom web applications I want a php & mysql automated code generator web application in which anyone who does not know programming can also create customized database centric php web applications which can be run online and offline also with help of wamp/xampp.. ...

• Php/mysql Application Updates Needed Hi, I need help with adding a new layout and code refactoring on my application. This is a unique application built on cakephp framework. This application is basically task manager for provisioning users Please review the project requirements and how the application works locat ...