RECHERCHE ENTRE DEUX DATES
Posté : 10 sept. 2014, 13:39
bonjour j'aimerais faire une recherche entre deux dates mais ça ne marche pas encore!!
voici ma requete!
<?php
$row_date="";
if(!empty($_POST['date1']) && !empty($_POST['date2'])){
$date1=$_POST['date1'];
$date2=$_POST['date2'];
mysql_select_db($database_connexion, $connexion);
$query_date = "SELECT * FROM depart WHERE date_correspondance<='$date1' AND date_correspondance>='$date2' ";
$date = mysql_query($query_date, $connexion) or die(mysql_error());
$row_date = mysql_fetch_assoc($date);
$totalRows_date = mysql_num_rows($date);
}
?>
voici ma requete!
<?php
$row_date="";
if(!empty($_POST['date1']) && !empty($_POST['date2'])){
$date1=$_POST['date1'];
$date2=$_POST['date2'];
mysql_select_db($database_connexion, $connexion);
$query_date = "SELECT * FROM depart WHERE date_correspondance<='$date1' AND date_correspondance>='$date2' ";
$date = mysql_query($query_date, $connexion) or die(mysql_error());
$row_date = mysql_fetch_assoc($date);
$totalRows_date = mysql_num_rows($date);
}
?>