查询未正确运行

Question

I have a sqlquery which I have been playing around with in my php page BUT it isn't pulling out accurate results! I have starred at this so long now I can't see anything wrong! I am sure there is just a " or ' or ` in the wrong place!

<? 
$result = mysql_query("SELECT ReReferral_ID FROM ReReferral Where (`ReReferral_Date` >= '" . $_POST["report_date_from"] ."-04-01 00:00:00' AND `ReReferral_Date` <= '" . $_POST["report_date_from"] ."-06-30 00:00:00') AND ReReferral_ReReferral ='1'");
$num_rows = mysql_num_rows($result);
echo $num_rows;
?>

Thanks for the help!

Answer 1

try this:

 $rdate = mysql_real_escape_string($_POST["report_date_from"]);
 $result = mysql_query("SELECT ReReferral_ID FROM ReReferral 
          WHERE `ReReferral_Date` BETWEEN  CONCAT('$rdate','-04-01 00:00:00') 
          AND CONCAT('$rdate','-06-30 00:00:00') 
          AND ReReferral_ReReferral ='1' ");