require ('config/config.inc.php3');
HAUTPAGE("- Liste des petites annonces -");
include ("connect.inc.php3");
$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 "
Choisissez votre rubrique\n";
echo "
\n";
echo "\n";
echo "CHOIX | \n";
echo "Nombres d'annonces | \n";
echo "
\n";
$TableRep=mysql($database,"SELECT categorie, count(*) FROM $table WHERE affiche='O' group by categorie");
while($row = mysql_fetch_array($TableRep)) {
echo "".$row[0]." | ";
echo "".$row[1]." |
";
}
echo "
\n";
echo "
\n";
?>
BASPAGE();
?>