SQL SELECT日期从10天前失败

Question

I'm havig some trouble with SQL:

First, I insert the current date, using PHP-time():

mysql_query("
   INSERT INTO applicants (
      date_last_applied
   )
   VALUES (
      " . time() . "
   )
");

This works just fine. However, I only want to execute an action when that ^ was inserted 10 days ago:

$result = mysql_query("
   SELECT * FROM applicants WHERE date_last_applied < DATE_SUB(NOW(), INTERVAL 10 DAY)
");
while ($row = mysql_fetch_array($result)) 
    echo $row['id_member'];

Although it should work (IMO), it doesn't. D:

For possible solutions: it's not an option to use an other timeformat, because I'm using this format on my entire site.

Answer 1

Ok, thanks for your help, y'all. This code works flawlessly:

 //get member's info
$result = mysql_query("
   SELECT * FROM DDFS_applicants 
   WHERE FROM_UNIXTIME(date_last_applied, '%Y %D %M') = FROM_UNIXTIME(UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 1 DAY)), '%Y %D %M')
");
while ($row = mysql_fetch_array($result)) {
    echo $row['id_member'];

(So it works even to check if the date is the exact same date. If you want, you can even add hours to it, but I chose not to.)

Source: http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_date-sub