Triez par type de transaction et de bien immobilier
include ("connect.inc.php3"); ?>
Triez par critères précis des caractéristiques de votre recherche
$TableRep=mysql($database,"SELECT * FROM $table WHERE affiche='O'");
$NombreEntrees=mysql_NumRows( $TableRep);
if($NombreEntrees == 0) /* La table est vide */
{
echo "La base est vide";
}
else
{
// echo "
Il y a actuellement ". $NombreEntrees." petites annonces.
";
}
echo "
Répartition des $NombreEntrees annonces
";
echo "
";
echo "
Catégorie de bien
";
echo "
Vente
";
echo "
Location
";
echo "
";
echo "
IMMEUBLES
";
$RepVteImm=mysql($database,"SELECT * FROM $table WHERE choix='VENTE' AND categorie='IMMEUBLES'");
$nb1 =mysql_num_rows($RepVteImm);
$RepLocImm=mysql($database,"SELECT * FROM $table WHERE choix='LOCATION' AND categorie='IMMEUBLES'");
$nb2 =mysql_num_rows($RepLocImm);
echo "
$nb1
";
echo "
$nb2
";
echo "
";
$RepVteApt=mysql($database,"SELECT * FROM $table WHERE choix='VENTE' AND categorie='APPARTEMENTS'");
$nb11 =mysql_num_rows($RepVteApt);
$RepLocApt=mysql($database,"SELECT * FROM $table WHERE choix='LOCATION' AND categorie='APPARTEMENTS'");
$nb12 =mysql_num_rows($RepLocApt);
echo "
APPARTEMENTS
";
echo "
$nb11
";
echo "
$nb12
";
echo "
";
$RepVteMai=mysql($database,"SELECT * FROM $table WHERE choix='VENTE' AND categorie='MAISONS'");
$nb21 =mysql_num_rows($RepVteMai);
$RepLocMai=mysql($database,"SELECT * FROM $table WHERE choix='LOCATION' AND categorie='MAISONS'");
$nb22 =mysql_num_rows($RepLocMai);
echo "
MAISONS
";
echo "
$nb21
";
echo "
$nb22
";
echo "
";
$RepVteLof=mysql($database,"SELECT * FROM $table WHERE choix='VENTE' AND categorie='LOFTS'");
$nb31 =mysql_num_rows($RepVteLof);
$RepLocLof=mysql($database,"SELECT * FROM $table WHERE choix='LOCATION' AND categorie='LOFTS'");
$nb32 =mysql_num_rows($RepLocLof);
echo "
LOFTS
";
echo "
$nb31
";
echo "
$nb32
";
echo "
";
$RepVteBur=mysql($database,"SELECT * FROM $table WHERE choix='VENTE' AND categorie='BUREAUX'");
$nb41 =mysql_num_rows($RepVteBur);
$RepLocBur=mysql($database,"SELECT * FROM $table WHERE choix='LOCATION' AND categorie='BUREAUX'");
$nb42 =mysql_num_rows($RepLocBur);
echo "
BUREAUX
";
echo "
$nb41
";
echo "
$nb42
";
echo "
";
$RepVteAut=mysql($database,"SELECT * FROM $table WHERE choix='VENTE' AND categorie='COMMERCES'");
$nb51 =mysql_num_rows($RepVteAut);
$RepLocAut=mysql($database,"SELECT * FROM $table WHERE choix='LOCATION' AND categorie='COMMERCES'");
$nb52 =mysql_num_rows($RepLocAut);
echo "
COMMERCES
";
echo "
$nb51
";
echo "
$nb52
";
echo "
";
$RepVteAut=mysql($database,"SELECT * FROM $table WHERE choix='VENTE' AND categorie='AUTRES'");
$nb51 =mysql_num_rows($RepVteAut);
$RepLocAut=mysql($database,"SELECT * FROM $table WHERE choix='LOCATION' AND categorie='AUTRES'");
$nb52 =mysql_num_rows($RepLocAut);
echo "