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);
?>
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)) {
?>
