$sql = " date BETWEEN '" . (!empty($date_debut) ? $date_debut : "0000-00-00") . "' AND '" . (!empty($date_fin) ? $date_fin : "2027-01-01") . "'"; return $sql; } } if ($filtreDateDebut != '') { $filtre_date_debut = $filtreDateDebut; $filtre_date_fin = $filtreDateFin; } //CSql::between($filtre_date_debut, $filtre_date_fin); if ($_GET['recherche'] == '') $filtre = "etat like '" . $filtre_etat . "' AND " . CSql::between($filtre_date_debut, $filtre_date_fin); else $filtre = "nom_ent like '".$_GET['recherche']."%'"; //print_r($filtre); $r_rdv = CTablContact::select("*", $filtre, $order); ?> <!-- InstanceEndEditable --> <div id="mainwrap"> <div id="header"><?php include("../nav/header.php"); ?></div> <div id="top"><?php include("../nav/menu_h.php"); ?></div> <div id="filet"> <div id="zonetitre"> <div id="signe"></div> <div id="titre"><!-- InstanceBeginEditable name="titre" -->Rdv<!-- InstanceEndEditable --></div> </div> </div> <div id="contentarea"> <div id="left"><?php include("../nav/menu_g.php"); ?></div> <div id="center"> <div id="page"><!-- InstanceBeginEditable name="page" --><?php echo CHtml::get_toolbar(array('add'=>0, 'cancel'=>0)) ?><!-- InstanceEndEditable --></div>