MYSQL Help Needed with CURDATE()

[eMonk]

I'm trying to only fetch the rows where the expiry_date column is 3 days before today's date.

<?php

include("../includes/connect.php");

$query = "SELECT expiry_date FROM model WHERE expiry_date BETWEEN CURDATE() AND CURDATE() - INTERVAL 3 DAY";
$result = $db->query($query);

$num_results = $result->num_rows;

echo "$num_results";

?>

$num_results should echo "1" because there is 1 expiry_date column with "2011-11-17" but it's echoing "0". Any ideas?

[woj]

flip the 2 paramaters CURDATE() AND CURDATE() - INTERVAL 3 DAY

what you have there is like asking for all numbers between 5 and 3, you need to ask for all numbers between 3 and 5

[marlboroack]

Cool signature.

[eMonk]

That worked thanks woj!!