RSS\n"; if(isset($typebienSearch) && ($typebienSearch!=0 && $typebienSearch!="")) { $rqbase .= " AND ".$nomBase.".idType='".$typebienSearch."'"; } $critere = array(); $c = 0; if(isset($_GET['theme']) && ($_GET['theme']!=0 && $_GET['theme']!="")) { if(is_array($_GET['theme'])) { $critere[$c] = "AND produitsagence.idProduit IN (SELECT idProduit FROM relationthematique WHERE tableProduit ='particulier_achat' AND ("; $sql -> requete("SELECT * FROM thematique ORDER BY theme ASC",2); for($i=0;$i<$sql -> nbr_rows(2);$i++) { $theme = $sql -> farray(2); if($critere[$c] != "AND produitsagence.idProduit IN (SELECT idProduit FROM relationthematique WHERE tableProduit ='particulier_achat' AND (" && isset($_GET['theme'][$theme['id']]) ) { $critere[$c] .= " OR"; } if(isset($_GET['theme'][$theme['id']])) { $critere[$c] .= " idTheme='".$_GET['theme'][$theme['id']]."'"; } } $critere[$c] .= "))"; } $c++; } if(isset($_GET['nbrpieces']) && ($_GET['nbrpieces']!=0 && $_GET['nbrpieces']!="")) { $critere[$c] = " AND ".$nomBase.".nbrPieces>='".$_GET['nbrpieces']."'"; $c++; } if(isset($_GET['nbrchambres']) && ($_GET['nbrchambres']!=0 && $_GET['nbrchambres']!="")) { $critere[$c] = " AND ".$nomBase.".nbrChambres>='".$_GET['nbrchambres']."'"; $c++; } if(isset($_GET['surfacemini']) && ($_GET['surfacemini']!=0 && $_GET['surfacemini']!="")) { $critere[$c] = " AND ".$nomBase.".surface_logement>='".$_GET['surfacemini']."'"; $c++; } if(isset($_GET['surfacemaxi']) && ($_GET['surfacemaxi']!=0 && $_GET['surfacemaxi']!="")) { $critere[$c] = " AND ".$nomBase.".surface_logement<='".$_GET['surfacemaxi']."'"; $c++; } if(isset($_GET['budgetmini']) && ($_GET['budgetmini']!=0 && $_GET['budgetmini']!="")) { $critere[$c] = " AND ".$nomBase.".prix>='".$_GET['budgetmini']."'"; $c++; } if(isset($_GET['budgetmaxi']) && ($_GET['budgetmaxi']!=0 && $_GET['budgetmaxi']!="")) { $critere[$c] = " AND ".$nomBase.".prix<='".$_GET['budgetmaxi']."'"; $c++; } if(isset($_GET['etat']) && $_GET['etat']!="") { $critere[$c] = " AND ".$nomBase.".etat='".$_GET['etat']."'"; $c++; } if(isset($_GET['surface_terrasse']) && ($_GET['surface_terrasse']!=0 && $_GET['surface_terrasse']!="")) { $critere[$c] = " AND ".$nomBase.".surface_terrasse>='".$_GET['surface_terrasse']."'"; $c++; } if(isset($_GET['surface_balcon']) && ($_GET['surface_balcon']!=0 && $_GET['surface_balcon']!="")) { $critere[$c] = " AND ".$nomBase.".surface_balcon>='".$_GET['surface_balcon']."'"; $c++; } if(isset($_GET['sdb']) && ($_GET['sdb']!=0 && $_GET['sdb']!="")) { $critere[$c] = " AND ".$nomBase.".sdb>='".$_GET['sdb']."'"; $c++; } if(isset($_GET['sde']) && ($_GET['sde']!=0 && $_GET['sde']!="")) { $critere[$c] = " AND ".$nomBase.".sde>='".$_GET['sde']."'"; $c++; } if(isset($_GET['chauffage']) && ($_GET['chauffage']!=0 && $_GET['chauffage']!="")) { $critere[$c] = " AND ".$nomBase.".chauffage='".$_GET['chauffage']."'"; $c++; } if(isset($_GET['toilettes']) && ($_GET['toilettes']!=0 && $_GET['toilettes']!="")) { $critere[$c] = " AND ".$nomBase.".toilettes>='".$_GET['toilettes']."'"; $c++; } if(isset($_GET['surface_sejour']) && ($_GET['surface_sejour']!=0 && $_GET['surface_sejour']!="")) { $critere[$c] = " AND ".$nomBase.".surface_sejour>='".$_GET['surface_sejour']."'"; $c++; } if(isset($_GET['double_sejour']) && $_GET['double_sejour']!="") { $critere[$c] = " AND ".$nomBase.".double_sejour='".$_GET['double_sejour']."'"; $c++; } if(isset($_GET['rangements']) && $_GET['rangements']!="") { $critere[$c] = " AND ".$nomBase.".rangements='".$_GET['rangements']."'"; $c++; } if(isset($_GET['cheminee']) && $_GET['cheminee']!="") { $critere[$c] = " AND ".$nomBase.".cheminee='".$_GET['cheminee']."'"; $c++; } if(isset($_GET['piscine']) && $_GET['piscine']!="") { $critere[$c] = " AND ".$nomBase.".piscine='".$_GET['piscine']."'"; $c++; } if(isset($_GET['garage']) && $_GET['garage']!="") { $critere[$c] = " AND ".$nomBase.".garage='".$_GET['garage']."'"; $c++; } if(isset($_GET['box']) && $_GET['box']!="") { $critere[$c] = " AND ".$nomBase.".box='".$_GET['box']."'"; $c++; } if(isset($_GET['climatisation']) && $_GET['climatisation']!="") { $critere[$c] = " AND ".$nomBase.".clim='".$_GET['climatisation']."'"; $c++; } if(isset($_GET['handicapees']) && $_GET['handicapees']!="") { $critere[$c] = " AND ".$nomBase.".handicapees='".$_GET['handicapees']."'"; $c++; } $noMatch = false; $rq = makeRQ($rqbase,$critere,$c); if(isset($_GET['order'])) $order = $_GET['order']; else $order = "prix"; if(isset($_GET['orderType'])) $orderType = $_GET['orderType']; else $orderType = "ASC"; $rq .= " GROUP BY ".$nomBase.".id ORDER BY ".$nomBase.".".$order." ".$orderType.""; //echo $rq; $sql -> requete($rq,1); $nbr_r = $sql -> nbr_rows(1); //echo $rq." LIMIT 0,10"; if(isset($_GET['p'])) $page = $_GET['p']; else $page = 1; ?>

Résultats de la recherche : "Achat - Maison - MAROLLES EN HUREPOIX"

Nouvelle recherche Modifier la recherche

sql_erreur : Impossible d'effectuer la requête.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT -10,10' at line 1