""){ $sSQLLocal = $sSQLLocal . "locaux.CodeL = ".Stripslashes($CodeL)." and "; $liensLocal = $liensLocal."CodeL=".$CodeL."&"; } if ($Nom <> "") { $sSQLLocal= $sSQLLocal."locaux.Nom Like '".StripSlashes($Nom)."%' and "; $liensLocal = $liensLocal."Nom=".$Nom."&"; } if ($Discription <> "") { $sSQLLocal= $sSQLLocal."locaux.Description Like '".Stripslashes($Discription)."%' and "; $liensLocal = $liensLocal."Description=".$Discription."&"; } if ($TypeUtilisation <> ""){ $sSQLLocal = $sSQLLocal."locaux.TypeUtilisation Like '".Stripslashes($TypeUtilisation)."%' and "; $liensLocal = $liensLocal."TypeUtilisation=".$TypeUtilisation."&"; } if ($StatutLocal <> "" ) { $sSQLLocal = $sSQLLocal."locaux.Statut = '".Stripslashes($StatutLocal)."' and "; $liensLocal = $liensLocal."StatutLocal=".$StatutLocal."&" ; } if ($Capacite <> "" ) { $sSQLLocal = $sSQLLocal."locaux.Capacite = " .$Capacite. " and "; $liensLocal = $liensLocal."Capacite=".$Capacite."&"; } if ($Cout <> "" ) { $sSQLLocal = $sSQLLocal ."locaux.Cout = ".$Cout. " and "; $liensLocal = $liensLocal."Cout=".$Cout."&"; } if ($CoutM <> "" ) { $sSQLLocal = $sSQLLocal ."locaux.CoutM = ".$CoutM. " and "; $liensLocal = $liensLocal."CoutM=".$CoutM."&"; } if ($sSQLLocal == "") header("Location: RechercheLocalF.php"); if (isset( $_REQUEST["p"]) ) $p = $_REQUEST["p"]; else $p ="1 "; $liensLocal = $liensLocal."p=".$p.""; setcookie('cookie_lienslocal', $liensLocal, (time() + 3600)); $url = "RechercheLocal.php?".substr($liensLocal, 0, strlen($liensLocal) - 4) ; $sSQL = "SELECT * FROM locaux WHERE ".substr($sSQLLocal, 0,strlen($sSQLLocal) - 4)." order by Nom"; $sql=substr($sSQL, 8); $pagine = pagine($sql,10,"p",$url); $rsQuery1 = mysql_query("SELECT * ".$sql); if (!$rsQuery1) { die('Could not query:' . mysql_error()); } if(!isset($rien)) $rien=false; if (mysql_num_rows($rsQuery1)==0) $rien=true; include "../include/top.inc"; /*********************************************Affichage*****************************/ ?>

Liste des locaux

Nom	Description	Modifier	Supprimer
">		">
">		">