RE: [PHP-DB] Re: Query and Date problem

> "Jeff Oien" <jeff@webdesigns1.com> wrote in message > news:PGEBKOPJJHHICHGDKCCIOECLDAAA.jeff@webdesigns1.com... > > I want to retrieve the last 15 days of data from a certain time but > > not today's. I have this but it's still giving me today's data: > > > > $today = date("Y-m-d"); > > $sql = "SELECT volume, date, time, id > > FROM $table_name > > where time = $time1 and date != $today ORDER by id desc LIMIT 15"; > > > > (date != $today) code in question > > > > When I print $today it's: 2001-08-15 and the date field in the database > > is also displaying as 2001-08-15. Any suggestions? Thanks in advance. > > Jeff Oien > > ... I would not depend on id being monotonic > (it probably will be, but I would still not > depend on it). > > How 'bout > > SELECT volume,date,time,id > FROM $table > WHERE time=$time1 > ORDER BY date DESC > LIMIT 1,15 > > What are you storing time as - a timestamp > rounded down to the last half-hour? That works also, thanks. The cron job runs on the half hour so the timestamp is always HH00 or HH30. I check to see what time it is now and then finds the data from the same half hour time period for the last 15 days. Jeff Oien