Ron Piggott wrote:
I am trying to write a mySQL query on my "stats" table. I am trying to
determine the number of records (users) during a 7 day period ending
yesterday. I always to keep it current ... Yesterday will keep changing.
In other words I want to know the number of users who accessed the web
site during seven full days.
This is the beginning of the query. The date column is "date".
SELECT count(`visits`) as users FROM `stats` WHERE `date`
The mysql manual is a good place to start.
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_date-sub
--
Postgresql & php tutorials
http://www.designmagick.com/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
