Wednesday, August 15, 2001 10:18 AM
> To: PHP-DB
> Subject: [PHP-DB] Query and Date problem
>
>
> 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(&quo
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