$languetest="FR";
$recup_equipement_liste=mysql_query("select ID_equipement, libelle from golfs_equipement where langue='$languetest' order by ID_equipement ASC");
while (list($ID_equipement, $libelle)=mysql_fetch_row($recup_equipement_liste)) {
$tbl_equipement_liste[]=array($ID_equipement,$libelle);
$tbl_equipement_liste_lib[$ID_equipement]=$libelle;
}
$recup_voiturettes_liste=mysql_query("select ID_voiturettes , libelle from golfs_voiturettes where langue='$languetest' order by libelle ASC");
while (list($ID_voiturettes, $libelle)=mysql_fetch_row($recup_voiturettes_liste)) {
$tbl_voiturettes_liste[]=array($ID_voiturettes,$libelle);
$tbl_voiturettes_liste_lib[$ID_voiturettes]=$libelle;
}
$recup_restaurant_liste=mysql_query("select ID_restaurant , libelle from golfs_restaurant where langue='$languetest' order by libelle ASC");
while (list($ID_restaurant, $libelle)=mysql_fetch_row($recup_restaurant_liste)) {
$tbl_restaurant_liste[]=array($ID_restaurant,$libelle);
$tbl_restaurant_liste_lib[$ID_restaurant]=$libelle;
}
$recup_hotel_liste=mysql_query("select ID_hotellerie , libelle from golfs_hotellerie where langue='$languetest' order by libelle ASC");
while (list($ID_hotellerie, $libelle)=mysql_fetch_row($recup_hotel_liste)) {
$tbl_hotel_liste[]=array($ID_hotellerie,$libelle);
$tbl_hotel_liste_lib[$ID_hotellerie]=$libelle;
}
$recup_region = mysql_query("select ID_region, libelle_region from golfs_liste_regions where LANGUE='$languetest' and ID_PAYS='13' order by libelle_region ASC");
while (list($ID_region, $libelle_region)=mysql_fetch_row($recup_region)) {
$libelle_region = str_replace("zzz","",$libelle_region);
$tbl_region_liste[]=array($ID_region,$libelle_region);
$tbl_region_liste_lib[$ID_region]=$libelle_region;
}
$recup_pays = mysql_query("select ID_PAYS, libelle from golfs_liste_pays where LANGUE='$languetest' order by libelle ASC");
while (list($ID_PAYS,$libelle)=mysql_fetch_row($recup_pays)) {
$tbl_pays_liste[]=array($ID_PAYS,$libelle);
$tbl_pays_liste_lib[$ID_PAYS]=$libelle;
}
$recup_nomsG = mysql_query("select id_golf, nom_golf from golfs order by nom_golf ASC");
while (list($id_golf,$nom_golf)=mysql_fetch_row($recup_nomsG)) {
$tbl_golfs_liste[]=array($id_golf,$nom_golf);
$tbl_golfs_liste_lib[$id_golf]=$nom_golf;
}
$recup_departs = mysql_query("select id_region, libelle, departement_num from golfs_liste_departements order by departement_num ASC");
while (list($id_region, $libelle, $departement_num)=mysql_fetch_row($recup_departs)) {
$tbl_depart_liste[]=array($departement_num,$departement_num." (".$libelle.")");
$tbl_depart_liste_lib[$departement_num]=$departement_num." (".$libelle.")";
}
$filterliste = isset($_REQUEST["filterliste"]) ? $_REQUEST["filterliste"] : null;
if ($filterliste == 1) {
$Fgolf_nom = $_REQUEST["Fgolf_nom"];
$Fpays = $_REQUEST["Fpays"];
$Fregion = $_REQUEST["Fregion"];
$Fdepartement = $_REQUEST["Fdepartement"];
if (strlen($Fgolf_nom) > 0) {
$_SESSION["golf_nom"] = $Fgolf_nom."";
} else {
$_SESSION["golf_nom"] = "";
}
if (strlen($Fpays) > 0) {
$_SESSION["pays"] = $Fpays."";
} else {
$_SESSION["pays"] = "";
}
if (strlen($Fregion) > 0) {
$_SESSION["region"] = $Fregion."";
} else {
$_SESSION["region"] = "";
}
if (strlen($Fdepartement) > 0) {
$_SESSION["departement"] = $Fdepartement."";
} else {
$_SESSION["departement"] = "";
}
}
if (!isset($_SESSION["sortgolflist"])) {
$_SESSION["sortgolflist"]=" order by golfs.nom_golf ASC";
}
$filterDB="";
if (isset($_SESSION['golf_nom']) and strlen($_SESSION["golf_nom"])>0) {
$filterDB .=" AND golfs.id_golf='".$_SESSION["golf_nom"]."' ";
}
if (isset($_SESSION['pays']) and strlen($_SESSION["pays"])>0) {
$filterDB .=" AND golfs.pays='".$_SESSION["pays"]."'";
}
if (isset($_SESSION['region']) and strlen($_SESSION["region"])>0) {
$filterDB .=" AND golfs.ID_region='".$_SESSION["region"]."'";
}
if (isset($_SESSION['departement']) and strlen($_SESSION["departement"])>0) {
$filterDB .=" AND golfs.code_postal like '".$_SESSION["departement"]."%'";
}
$sortici = $_SESSION["sortgolflist"];
$recup_all_golfs = " select
golfs.id_golf, golfs.nom_golf, golfs.adresse, golfs.code_postal, golfs.ville, golfs.pays,
golfs.site_web, golfs.telephone, golfs.fax, golfs.ID_reseau,
golfs.ID_region, golfs.ID_equipement, golfs.ID_voiturettes, golfs.ID_restaurant, golfs.ID_hotellerie,
golfs_reseau.libelle,
golfs_liste_pays.libelle,
golfs_liste_regions.libelle_region
from golfs
left join golfs_reseau on golfs_reseau.ID_reseau=golfs.ID_reseau
left join golfs_liste_pays on golfs_liste_pays.ID_PAYS=golfs.pays
left join golfs_liste_regions on golfs_liste_regions.ID_region=golfs.ID_region
where etat_site=''
$filterDB
$sortici";
$rec = mysql_query($recup_all_golfs);
?>
if (mysql_num_rows($rec)>0) {
while (list($id_golf,$nom_golf,$adresse,$code_postal,$ville,$paysID,$site_web,$telephone,$fax,$ID_reseau,$ID_region,$ID_equipement,$ID_voiturettes,
$ID_restaurant,$ID_hotellerie,$libellereseau,$libellepays,$libelle_region)=mysql_fetch_row($rec)) {
?>
require "{$_SERVER['DOCUMENT_ROOT']}/includes/hotel_partenaire.php";
} }else { ?>
} ?>