mySQL date query
| From: | Ron Piggott | Date: | Tue, 13 Apr 2010 06:20:15 +0000 |
| Subject: | mySQL date query | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-47044@lists.php.net to get a copy of this message | ||
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