It is in a 'date' column type YYYY-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.piggott@xxxxxxxxxxxxxxxxxx> 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` >> >> Thanks, Ron >> >> >> -- >> PHP Database Mailing List (http://www.php.net/) >> To unsubscribe, visit: http://www.php.net/unsub.php >> >> > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
