");
$d1= '2018-01-19';
$d2= '2018-01-26';
$requet="
SELECT `table1`.`Num1`, `table3`.`Champ4`
FROM `table1`, `table3`, `table2`
Where `table1`.`Num1`= `table3`.`Num1` AND `table2`.`Num2`=`table3`.`Num2`
and `table1`.`Date1` >= '".$d1."' and `table1`.`Date1` <= '".$d2."' ";
/* Autre solution :
$requet="
SELECT `table3`.`Num1`, `table3`.`Champ4`
FROM `table3`
Where `table3`.`Num1`= '4' or `table3`.`Num1`='5'";
*/
$result=mysql_query($requet) or die("erreur de requete de base de données.
");
?>
| X |
Y |
$num |
$mont |
";
$ligne= mysql_fetch_row($result);
}
?>