[PHP-DB] Counting time in a stats table From: Stuart McDonald (stuart <email protected>)
Date: 12/28/00

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 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>