");
$d1= '2018-01-15';
$d2= '2018-01-31';
$requet="
SELECT `table1`.`Date1`, `table2`.`Champ3`
FROM `table1`, `table3`, `table2`
Where `table1`.`Num1`= `table3`.`Num1`
and `table2`.`Num2`= `table3`.`Num2`
and `table1`.`Date1` >= '".$d1."' and `table1`.`Date1` <= '".$d2."'
and `table2`.`Champ3` < '400'
and `table2`.`Champ3` > '100'";
$result=mysql_query($requet) or die("erreur de requete.
");
?>
X | Y | $num | $mont | "; $ligne= mysql_fetch_row($result); } ?>