Counting time in a stats table

From: Date: Fri, 29 Dec 2000 02:14:40 +0000
Subject: Counting time in a stats table
References: 1 2  Groups: php.db 
Request: Send a blank email to php-db+get-5512@lists.php.net to get a copy of this message
Hi all, I've got a table that records cookie information, with the columns ID (md5), Time(timestamp) and referer(varchar) What I want to do is run a query that will group the time values by date and count them (ignoring the referer so that I can get total number of visitors per day. So, the way I figure it, the query needs to format all the date entries so that it strips off the time (thus giving me just the date of the visit) - I can use DATE_FORMAT() for that, then I need to count the values for each of these days and display the result - unfotunately I can't get the counting to work. Any assistance or pointers on this would be greatly apprecaieted Cheers Stuart

« previous php.db (#5512) next »