1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90
| $sqlCri= "UPDATE rech_comprend_cri set ";
$sqlCri.="valeur= '".$ck_appart."' where fkRecherche=".$idRecherche." AND fkCritere=".cAppartC.";";
$sqlCri.= "UPDATE rech_comprend_cri set ";
$sqlCri.="valeur= '".$ck_loft."' where fkRecherche=".$idRecherche." AND fkCritere=".cLoftC.";";
$sqlCri.= "UPDATE rech_comprend_cri set ";
$sqlCri.="valeur= '".$ck_duplex."' where fkRecherche=".$idRecherche." AND fkCritere=".cDuplexC.";";
$sqlCri.= "UPDATE rech_comprend_cri set ";
$sqlCri.="valeur= '".$ck_maison."' where fkRecherche=".$idRecherche." AND fkCritere=".cMaisonC.",";
$sqlCri.= "UPDATE rech_comprend_cri set ";
$sqlCri.="valeur= '".$ck_loft."' where fkRecherche=".$idRecherche." AND fkCritere=".cLoftC.",";
$sqlCri.= "UPDATE rech_comprend_cri set ";
$sqlCri.="valeur= '".$ck_jt."' where fkRecherche=".$idRecherche." AND fkCritere=".cJTC.",";
$sqlCri.= "UPDATE rech_comprend_cri set ";
$sqlCri.="valeur= '".$ck_rdc."' where fkRecherche=".$idRecherche." AND fkCritere=".cRdcC.",";
$sqlCri.= "UPDATE rech_comprend_cri set ";
$sqlCri.="valeur= '".$ck_ancien."' where fkRecherche=".$idRecherche." AND fkCritere=".cAncienC.",";
$sqlCri.= "UPDATE rech_comprend_cri set ";
$sqlCri.="valeur= '".$ck_recent."' where fkRecherche=".$idRecherche." AND fkCritere=".cRecentC.",";
$sqlCri.= "UPDATE rech_comprend_cri set ";
$sqlCri.="valeur= '".$ck_moderne."' where fkRecherche=".$idRecherche." AND fkCritere=".cModerneC.",";
$sqlCri.= "UPDATE rech_comprend_cri set ";
$sqlCri.="valeur= '".$ck_neuf."' where fkRecherche=".$idRecherche." AND fkCritere=".cNeufC.",";
if ($cb_piecemin!=""){
$sqlCri.= "UPDATE rech_comprend_cri set ";
$sqlCri.="valeur= '".$cb_piecemin."' where fkRecherche=".$idRecherche." AND fkCritere=".cPieceMin.",";
}else{
$sqlCri.= "UPDATE rech_comprend_cri set ";
$sqlCri.="valeur=0 where fkRecherche=".$idRecherche." AND fkCritere=".cPieceMin.",";
}
if ($ef_prixmax!=""){
$sqlCri.= "UPDATE rech_comprend_cri set ";
$sqlCri.="valeur= '".$ef_prixmax."' where fkRecherche=".$idRecherche." AND fkCritere=".cPrixMax.",";
}else{
$sqlCri.= "UPDATE rech_comprend_cri set ";
$sqlCri.="valeur=999999999 where fkRecherche=".$idRecherche." AND fkCritere=".cPrixMax.",";
}
$sqlCri.= "UPDATE rech_comprend_cri set ";
$sqlCri.="valeur= '".$cb_asc."' where fkRecherche=".$idRecherche." AND fkCritere=".cAsc.",";
$sqlCri.= "UPDATE rech_comprend_cri set ";
$sqlCri.="valeur= '".$ef_ville1."' where fkRecherche=".$idRecherche." AND fkCritere=".cVille1.",";
$sqlCri.= "UPDATE rech_comprend_cri set ";
$sqlCri.="valeur= '".$ef_ville2."' where fkRecherche=".$idRecherche." AND fkCritere=".cVille2.",";
$sqlCri.= "UPDATE rech_comprend_cri set ";
$sqlCri.="valeur= '".$ef_ville3."' where fkRecherche=".$idRecherche." AND fkCritere=".cVille3.",";
$sqlCri.= "UPDATE rech_comprend_cri set ";
$sqlCri.="valeur= '".$ef_ville4."' where fkRecherche=".$idRecherche." AND fkCritere=".cVille4.",";
$sqlCri.= "UPDATE rech_comprend_cri set ";
$sqlCri.="valeur= '".$ef_ville5."' where fkRecherche=".$idRecherche." AND fkCritere=".cVille5.",";
$sqlCri.= "UPDATE rech_comprend_cri set ";
$sqlCri.="valeur= '".$ef_ville6."' where fkRecherche=".$idRecherche." AND fkCritere=".cVille6.",";
if ($cb_nbChambre!=""){
$sqlCri.= "UPDATE rech_comprend_cri set ";
$sqlCri.="valeur= '".$cb_nbChambre."' where fkRecherche=".$idRecherche." AND fkCritere=".cChambreMin.",";
}else{
$sqlCri.= "UPDATE rech_comprend_cri set ";
$sqlCri.="valeur=0 where fkRecherche=".$idRecherche." AND fkCritere=".cChambreMin.",";
}
if ($ef_ssmin!=""){
$sqlCri.= "UPDATE rech_comprend_cri set ";
$sqlCri.="valeur= '".$ef_ssmin."' where fkRecherche=".$idRecherche." AND fkCritere=".cSurfaceSejMin.",";
}else{
$sqlCri.= "UPDATE rech_comprend_cri set ";
$sqlCri.="valeur= 0 where fkRecherche=".$idRecherche." AND fkCritere=".cSurfaceSejMin.",";
}
if ($ef_surfacemin!=""){
$sqlCri.= "UPDATE rech_comprend_cri set ";
$sqlCri.="valeur= '".$ef_surfacemin."' where fkRecherche=".$idRecherche." AND fkCritere=".cSurfaceMin;
}else{
$sqlCri.= "UPDATE rech_comprend_cri set ";
$sqlCri.="valeur=0 where fkRecherche=".$idRecherche." AND fkCritere=".cSurfaceMin;
}
$req = mysql_query($sqlCri) or die('Erreur SQL !<br>'.$sqlCri.'<br>'.mysql_error()); |
Partager