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`
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php