Re: [PHP-DB] mySQL date query

what is the format of the date u are storing ? Chaitanya On Tue, Apr 13, 2010 at 11:50 AM, Ron Piggott ron.pigg...@actsministries.org 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

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

Re: [PHP-DB] mySQL date query

It is in a 'date' column type -MM-DD what is the format of the date u are storing ? Chaitanya On Tue, Apr 13, 2010 at 11:50 AM, Ron Piggott ron.pigg...@actsministries.org wrote: I am trying to write a mySQL query on my stats table. I am trying to determine the number of records

Re: [PHP-DB] mySQL date query

try this SELECT DATE_ADD('2008-01-02', INTERVAL -7 DAY); Chaitanya On Tue, Apr 13, 2010 at 12:01 PM, Ron Piggott ron.pigg...@actsministries.org wrote: It is in a 'date' column type -MM-DD what is the format of the date u are storing ? Chaitanya On Tue, Apr 13, 2010 at