Between Date Range

[timmah1]

Why is this not working?

$result = mysql_query("SELECT * FROM contacts WHERE type = 'consumer' AND sent BETWEEN '".date("Y-m-d")."' AND '".date("Y-m-d", strtotime("-7 days"))."'") 
or die(mysql_error());
$numrows = mysql_num_rows($result);
if($numrows < 0 ){
	echo "No records found";
}

 

The record that is stored in the sent column is like this "2011-11-03 14:42:12", so there is a record in there, but nothing is showing up.

 

Can anyone see why?

 

thanks in advance

[xyph]

You need the smaller date first.

http://dev.mysql.com/doc/refman/5.0/en/comparison-operators.html#operator_between

[timmah1]

Oh geesh.

 

Thanx. I knew it'd probably be something simple.

[xyph]

Always check the manual first