On Tue, Nov 17, 2009 at 4:17 PM, Ed Murphy <emurph...@socal.rr.com> wrote: > To be more specific: Each draws_by_week.php script works correctly, as > far as it goes. What they is a "leave out data more than X weeks old" > cutoff; instead, they include every week from (hardcoded start date) to > (end of the most recent week that has already ended). If you just go > by my published reports, then you can ignore this problem (I'll manually > trim the published list).
Ah... couldn't you limit the query to WHERE date > DATE_SUB(UTC_NOW(), 1 MONTH) or something like that (disclaimer: I may have the functions and/or syntax wrong). -coppro
