<?
//requete
$sql= "SELECT id_news, titre_news, DATE_FORMAT(publi_news,'%e/%m')as publi_news, rub_news FROM cer_news ORDER BY id_news DESC";

//exécute la requete
$req = mysql_query($sql); 

//compte le nombre de ligne et on met le resultat dans la variable total
$total = mysql_num_rows($req); 

//si total = 0 c'est vide
if ($total == 0) 
    { 
    echo'il n\'y a aucun enregistrement'; 
    } 

    else if ($total > 0) 
    { 
    //là tu met les instructions :
    while ($news = mysql_fetch_object ($req))
    ...
    }


?>

			$resultat = mysql_query ("SELECT id_news, titre_news, DATE_FORMAT(publi_news,'%e/%m')as publi_news, rub_news FROM cer_news ORDER BY id_news DESC", $connexion);
			
			if ($resultat) {
				while ($news = mysql_fetch_object ($resultat)) {
					echo "<p><span class='legende'>$news->publi_news</span> ";
					$sql_rub = mysql_query ("SELECT * FROM cer_rub");
						while ($valeur_sql = mysql_fetch_object ($sql_rub))
						if ($news->rub_news==$valeur_sql->id_rub) echo "<strong>$valeur_sql->nom_rub :</strong> ";
					echo "<a href='actualites1-$news->id_news.html'>$news->titre_news</a></p>"; } }
			else {
				echo "Erreur dans la requete"; }