mySQL date query
[email protected] ("Ron Piggott")
| Newsgroups | php.db |
|---|---|
| Message-ID | <54d8442668a0fa3ce230afd8d529f9cd.squirrel@www.theverseoftheday.info> |
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