query Problem

Hi all,

Why won't the below query work? Don't get any errors but the browser screen remains blank.

 $query = "SELECT id, name FROM ".$value." ".
 		"WHERE file_date = DATE_SUB(NOW(), INTERVAL 1 DAY);

Thanks,

Kevin.

Have you echoed the query?
Don't know whether the date_sub is used correctly, but:

$query = "SELECT id, name FROM ".$value." 
                 WHERE file_date = DATE_SUB(NOW(), INTERVAL 1 DAY)";

file_date is DATETIME column type?

NOW(): 2005-08-30 13:09:55

DATE_SUB(NOW(), INTERVAL 1 DAY): 2005-08-29 13:09:55
file_date: 2005-08-29 16:07:27

the date is the same but the time differs and so the two values are not equal.

maybe working with > or < might help or reading the manual concernig date and time functions of mysql might help (you can extract only the date part