Hi,
I'm using MYSQL version 3.22.32. I have read that from version 3.23.xx COUNT
can be used in combination with DISTINCT. However, I have a project deadline
which does not give me time to upgrade.
I have a small table 'web-stats' consisting of the following fields:
IP_address
web_date
web_time
web_referer
browser
page
I am using a PHP script to insert entries into this table as a rudimentary
hit counter.
My current syntax is
select web_date, dayofmonth(web_date) as d, count (IP_address) as c from
web_stats group by d order by web_date
but what I actually want is to count the unique IP addresses for each date.
How can I work around this please?
kind regards, Graham Nichols.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
