RE: [PHP-DB] Query and Date problem

2001-08-15 Thread Jeff Oien
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

[PHP-DB] Query and Date problem

2001-08-15 Thread Jeff Oien
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