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.

Postgresql & php tutorials

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to