$result2 = mysql_query("SELECT immo_id, immo_ref, immo_type, immo_ville, immo_quartier, immo_surface, immo_img, immo_piece, immo_jardin,immo_etage, immo_chauffage, immo_dpe, immo_terrasse, immo_parking, immo_desc, immo_info, immo_mandat, immo_num_mandat, immo_commercial, immo_nom, immo_tel, immo_prix, immo_hp, immo_diff, immo_etat, immo_cat,bannier FROM IMMO_PROJET WHERE immo_ref!='' and immo_cat='VENTE' and immo_diff!='NON' ORDER BY immo_mandat DESC LIMIT 0,12") or die(mysql_error());
$i="1";
while ($row4 = mysql_fetch_row($result2)) {
$immo_id=$row4[0];
$immo_ref=$row4[1];
$immo_type=$row4[2];
$immo_ville=$row4[3];
$immo_quartier=$row4[4];
$immo_surface=$row4[5];
$immo_img=$row4[6];
$immo_piece=$row4[7];
$immo_jardin=$row4[8];
$immo_etage=$row4[9];
$immo_chauffage=$row4[10];
$immo_dpe=$row4[11];
$immo_terrasse=$row4[12];
$immo_parking=$row4[13];
$immo_desc=$row4[14];
$immo_info=$row4[15];
$immo_mandat=$row4[16];
$immo_num_mandat=$row4[17];
$immo_commercial=$row4[18];
$immo_nom=$row4[19];
$immo_tel=$row4[20];
$immo_prix=$row4[21];
$immo_hp=$row4[22];
$immo_diff=$row4[23];
$immo_etat=$row4[24];
$immo_cat=$row4[25];
$bannier = $row4[26];
$immo_prix = number_format($immo_prix, 0, ' ', ' ');
//$com="
";
if($i=="1") echo"
";
if($i=="4") echo"
";
if($i=="7") echo"
";
if($i=="10") echo"
";
if($bannier != ""){
echo"
";
}else{
echo "
";
}
if($i=="3") echo"
";
if($i=="6") echo"
";
if($i=="9") echo"
";
if($i=="12") echo"
";
$i=$i+1;
}
if ( $i=="4" || $i=="7" || $i=="10" || $i=="13") { echo""; } else
{ echo"
"; }
?>
$result2 = mysql_query("SELECT immo_id, immo_ref, immo_type, immo_ville, immo_quartier, immo_surface, immo_img, immo_piece, immo_jardin,immo_etage, immo_chauffage, immo_dpe, immo_terrasse, immo_parking, immo_desc, immo_info, immo_mandat, immo_num_mandat, immo_commercial, immo_nom, immo_tel, immo_prix, immo_hp, immo_diff, immo_etat, immo_cat ,bannier FROM IMMO_PROJET WHERE immo_ref!='' and immo_cat='LOCATION' and immo_diff!='NON' ORDER BY immo_mandat DESC LIMIT 0,12") or die(mysql_error());
while ($row4 = mysql_fetch_row($result2)) {
$immo_id=$row4[0];
$immo_ref=$row4[1];
$immo_type=$row4[2];
$immo_ville=$row4[3];
$immo_quartier=$row4[4];
$immo_surface=$row4[5];
$immo_img=$row4[6];
$immo_piece=$row4[7];
$immo_jardin=$row4[8];
$immo_etage=$row4[9];
$immo_chauffage=$row4[10];
$immo_dpe=$row4[11];
$immo_terrasse=$row4[12];
$immo_parking=$row4[13];
$immo_desc=$row4[14];
$immo_info=$row4[15];
$immo_mandat=$row4[16];
$immo_num_mandat=$row4[17];
$immo_commercial=$row4[18];
$immo_nom=$row4[19];
$immo_tel=$row4[20];
$immo_prix=$row4[21];
$immo_hp=$row4[22];
$immo_diff=$row4[23];
$immo_etat=$row4[24];
$immo_cat=$row4[25];
$bannier = $row4[26];
$immo_prix = number_format($immo_prix, 0, ' ', ' ');
//$com="
";
if($bannier !=""){
echo"
Surface: $immo_surface m2
";
}else{
echo"
Surface: $immo_surface m2
";
}
} ?>
$result2 = mysql_query("SELECT immo_id, immo_ref, immo_type, immo_ville, immo_quartier, immo_surface, immo_img, immo_piece, immo_jardin,immo_etage, immo_chauffage, immo_dpe, immo_terrasse, immo_parking, immo_desc, immo_info, immo_mandat, immo_num_mandat, immo_commercial, immo_nom, immo_tel, immo_prix, immo_hp, immo_diff, immo_etat, immo_cat FROM IMMO_PROJET WHERE immo_cat='NEUF' and immo_diff!='NON' ORDER BY immo_mandat DESC LIMIT 0,12") or die(mysql_error());
while ($row4 = mysql_fetch_row($result2)) {
$immo_id=$row4[0];
$immo_ref=$row4[1];
$immo_type=$row4[2];
$immo_ville=$row4[3];
$immo_quartier=$row4[4];
$immo_surface=$row4[5];
$immo_img=$row4[6];
$immo_piece=$row4[7];
$immo_jardin=$row4[8];
$immo_etage=$row4[9];
$immo_chauffage=$row4[10];
$immo_dpe=$row4[11];
$immo_terrasse=$row4[12];
$immo_parking=$row4[13];
$immo_desc=$row4[14];
$immo_info=$row4[15];
$immo_mandat=$row4[16];
$immo_num_mandat=$row4[17];
$immo_commercial=$row4[18];
$immo_nom=$row4[19];
$immo_tel=$row4[20];
$immo_prix=$row4[21];
$immo_hp=$row4[22];
$immo_diff=$row4[23];
$immo_etat=$row4[24];
$immo_cat=$row4[25];
$immo_prix = number_format($immo_prix, 0, ' ', ' ');
//$com="
";
echo"
Surface: $immo_surface m2
"; } ?>
$result2 = mysql_query("SELECT immo_id, immo_ref, immo_type, immo_ville, immo_quartier, immo_surface, immo_img, immo_piece, immo_jardin,immo_etage, immo_chauffage, immo_dpe, immo_terrasse, immo_parking, immo_desc, immo_info, immo_mandat, immo_num_mandat, immo_commercial, immo_nom, immo_tel, immo_prix, immo_hp, immo_diff, immo_etat, immo_cat FROM IMMO_PROJET WHERE immo_ref!='' and immo_cat='BAIL' and immo_diff!='NON' ORDER BY immo_mandat DESC LIMIT 0,12") or die(mysql_error());
while ($row4 = mysql_fetch_row($result2)) {
$immo_id=$row4[0];
$immo_ref=$row4[1];
$immo_type=$row4[2];
$immo_ville=$row4[3];
$immo_quartier=$row4[4];
$immo_surface=$row4[5];
$immo_img=$row4[6];
$immo_piece=$row4[7];
$immo_jardin=$row4[8];
$immo_etage=$row4[9];
$immo_chauffage=$row4[10];
$immo_dpe=$row4[11];
$immo_terrasse=$row4[12];
$immo_parking=$row4[13];
$immo_desc=$row4[14];
$immo_info=$row4[15];
$immo_mandat=$row4[16];
$immo_num_mandat=$row4[17];
$immo_commercial=$row4[18];
$immo_nom=$row4[19];
$immo_tel=$row4[20];
$immo_prix=$row4[21];
$immo_hp=$row4[22];
$immo_diff=$row4[23];
$immo_etat=$row4[24];
$immo_cat=$row4[25];
$immo_prix = number_format($immo_prix, 0, ' ', ' ');
//$com="
";
echo"
$immo_prix €
$immo_piece
Surface: $immo_surface m2
"; } ?>
$result2 = mysql_query("SELECT immo_id, immo_ref, immo_type, immo_ville, immo_quartier, immo_surface, immo_img, immo_piece, immo_jardin,immo_etage, immo_chauffage, immo_dpe, immo_terrasse, immo_parking, immo_desc, immo_info, immo_mandat, immo_num_mandat, immo_commercial, immo_nom, immo_tel, immo_prix, immo_hp, immo_diff, immo_etat, immo_cat FROM IMMO_PROJET WHERE immo_ref!='' and immo_type='TERRAIN' and immo_diff!='NON' ORDER BY immo_mandat DESC LIMIT 0,12") or die(mysql_error());
while ($row4 = mysql_fetch_row($result2)) {
$immo_id=$row4[0];
$immo_ref=$row4[1];
$immo_type=$row4[2];
$immo_ville=$row4[3];
$immo_quartier=$row4[4];
$immo_surface=$row4[5];
$immo_img=$row4[6];
$immo_piece=$row4[7];
$immo_jardin=$row4[8];
$immo_etage=$row4[9];
$immo_chauffage=$row4[10];
$immo_dpe=$row4[11];
$immo_terrasse=$row4[12];
$immo_parking=$row4[13];
$immo_desc=$row4[14];
$immo_info=$row4[15];
$immo_mandat=$row4[16];
$immo_num_mandat=$row4[17];
$immo_commercial=$row4[18];
$immo_nom=$row4[19];
$immo_tel=$row4[20];
$immo_prix=$row4[21];
$immo_hp=$row4[22];
$immo_diff=$row4[23];
$immo_etat=$row4[24];
$immo_cat=$row4[25];
$immo_prix = number_format($immo_prix, 0, ' ', ' ');
//$com="
";
echo"
$immo_prix €
$immo_piece
Surface: $immo_surface m2
"; } ?>