");
$d1= '2018-01-15';
$d2= '2018-01-25';
$requet="
SELECT `table2`.`Champ2`, `table3`.`Champ4`
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'";
/* Autre Solution :
$requet="
SELECT `table2`.`Champ2`, `table3`.`Champ4`
FROM `table3`, `table2`
Where `table1`.`Num1`= `table3`.`Num1` AND `table2`.`Num2`=`table3`.`Num2`
and `table2`.`Champ2` = 'Valeur25'
and `table2`.`Champ2` = 'Valeur26'";
*/
$result=mysql_query($requet) or die("erreur de requete de base de données.
");
?>
| X |
Y |
$num |
$mont |
";
$ligne= mysql_fetch_row($result);
}
?>