"Jeff Oien" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> 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?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
