Re: [PHP-DB] mySQL date query

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.

http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_date-sub

-- 
Postgresql & php tutorials
http://www.designmagick.com/