$varRSS = "pBase=".$_GET['pBase'];
$varRSS .= "&investissement=".$investissement;
$varRSS .= "&urlerreur=".$_GET['urlerreur'];
$varRSS .= "&typebien=".$typebienSearch;
$varRSS .= "&situationgeo=".$situationgeo;
$varRSS .= "&budgetmini=".$_GET['budgetmini'];
$varRSS .= "&budgetmaxi=".$_GET['budgetmaxi'];
$varRSS .= "&surfacemini=".$_GET['surfacemini'];
$varRSS .= "&surfacemaxi=".$_GET['surfacemaxi'];
$varRSS .= "&nbrpieces=".$_GET['nbrpieces'];
$varRSS .= "&nbrchambres=".$_GET['nbrchambres'];
//echo "
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 - Appartement - VIGNEUX SUR SEINE"
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