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`

Thanks, Ron

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to