Counting time in a stats table
| From: | Stuart McDonald | 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