Date intervalle php mysql

Vous avez raison, mais j'ai changer la form comme ceci:


if(isset ($_POST['begin']) && isset($_POST['end']))
{
$day1=date("d",strtotime($_POST['begin']));
$month1=date("m",strtotime($_POST['begin']));
$year1=date("Y",strtotime($_POST['begin']));
//--------------------------------------//
$day2=date("d",strtotime($_POST['end']));
$month2=date("m",strtotime($_POST['end']));
$year2=date("Y",strtotime($_POST['end']));
//--------------------------------------//
$Hour='0';
$minute='0';
$second='0';
//---------------------------------------//
$date0="$year1-$month1-$day1" ;
$date00="$year2-$month2-$day2" ;
$time0="$Hour:$minute:second";
list($year1,$month1,$day1)=explode("-",$date0);
list($year2,$month2,$day2)=explode("-",$date00);
list($Hour,$minute,$second)=explode(":",$time0);
$date01=mktime($Hour,$minute,$second,$month1,$day1,$year1);
$date02=mktime($Hour,$minute,$second,$month2,$day2,$year2);
$date1=date("Y-m-d H:i:s",$date01);
$date2=date("Y-m-d H:i:s",$date02);
//---------------------------------------//


$strSQL = "SELECT upstream, downstream, crestlevel, Timedate FROM Solecluse1 WHERE Timedate BETWEEN '$date1' AND '$date2' ORDER BY Timedate ASC ";

$result = db_query($strSQL, $DBLink) or die ('Request Error!');
}


quand j'ai fait : echo $strSQL; ca affiche la requete avec l'intervalle de temps, mais ca ne retenu pas en compte dans le graph car j'ai rien dans le graph; comme s'il n'est y a pas de dates.