: : I am trying to get a count of Distinct IP's from my homemade hit-log : database (don't ask). The db is MySQL. I'm trying this: : : SELECT DISTINCT ClientIP, COUNT(*), Month(TimeStamp), : DayOfMonth(TimeStamp) FROM RedirectLog WHERE (TimeStamp BETWEEN : '20030130000000' AND '20030131000000') GROUP BY Month(TimeStamp), : DayOfMonth(TimeStamp)
Looks like you are working on a project similar to http://traffic.handalak.com (login: demo password: demo). In the above example, you're trying to retrieve how many times a unique user (arguably) visited a site on certain month? In that case, you need to drop distinct and group it by IP address and specify the date inside WHERE clause. Simplified version would look something like: SELECT ClientIP, COUNT(*) FROM redirectLog WHERE MONTH(timeStamp) = MONTH(CURDATE()) GROUP BY clientIP; Good luck Sherzod --------------------------------------------------------------------- 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