"; } else $affiche_news = @mysql_db_query("$base", "SELECT * FROM $DB_NEWS ORDER BY id desc LIMIT 0,12", $connexion); echo "
"; if (@mysql_num_rows($affiche_news) == 0) echo "Aucune news pour l'instant"; else include ("news.inc"); echo "
";
if (isset($sujet)) $affiche_news = @mysql_db_query("$base", "SELECT * FROM $DB_DOSSIER WHERE type=$sujet ORDER BY titre", $connexion);
else $affiche_news = @mysql_db_query("$base", "SELECT * FROM $DB_DOSSIER ORDER BY id desc LIMIT 0,5", $connexion);
if (@mysql_num_rows($affiche_news) == 0) echo "Aucun dossier pour l'instant";
else {
for ($i=0; $i < @mysql_num_rows($affiche_news); $i++){
$titrenews = @mysql_result($affiche_news, $i, "titre");
$auteurnews = @mysql_result($affiche_news, $i, "auteur");
$affiche_auteur = @mysql_db_query("$base", "SELECT pseudo FROM $DB_ADMIN where id=$auteurnews", $connexion);
if (@mysql_num_rows($affiche_auteur) == 0) $auteurnews = 'Inconnu';
else $auteurnews = @mysql_result($affiche_auteur, 0, "pseudo");
$idnews = @mysql_result($affiche_news, $i, "id");
$typenews = @mysql_result($affiche_news, $i, "type");
$affiche_type = @mysql_db_query("$base", "SELECT * FROM $DB_TYPE where id=$typenews", $connexion);
if (@mysql_num_rows($affiche_type) == 0) $typenews = 'Type de news indéfinie';
else {
$idperetypenews = @mysql_result($affiche_type, 0, "id_pere");
if ($idperetypenews == 0) $typenews = @mysql_result($affiche_type, 0, "titre");
else {
$affiche_type_pere = @mysql_db_query("$base", "SELECT * FROM $DB_TYPE where id = $idperetypenews", $connexion);
if (@mysql_num_rows($affiche_type_pere) == 0) $typenews = @mysql_result($affiche_type, 0, "titre");
else {
$typenews = @mysql_result($affiche_type_pere, 0, "titre");
$typenews .= ' >> ';
$typenews .= @mysql_result($affiche_type, 0, "titre");
}
}
}
echo "$titrenews par $auteurnews
Catégorie : $typenews
"; } } require ("footer.inc"); } ?>