Module de news php

<?

// Include de la connexion sql

include('Templates/sql.php') ;

// Requete sql pour récupérer les news

$requete_news = mysql_query("SELECT * FROM news ORDER BY id DESC",$connexion);

$news = mysql_num_rows($requete_news);

?>

<br><br>

<?

$i = 0;

for ($i=$news; $i>($news-14); $i--)  {

// Variables date

$date = mysql_result($requete_news,$i,"date");

$annee = date("Y", $date);

$mois = date("m", $date);

$jour = date("d", $date);

$heure = date("H", $date);

$minute = date("i", $date);

$date = $jour."/".$mois."/".$annee." à ".$heure."h".$minute;

// Autres variables

$titre = mysql_result($requete_news,$i,"titre");

$source = mysql_result($requete_news,$i,"source");

$texte = mysql_result($requete_news,$i,"texte");

// Affichage de la news //

// Titre

echo '<table border="0" bgcolor="#000000"  width="550"><tr><td width="50%" height="30" background="images/fondnews.jpg" colspan="0" class="style1"><center>'.$titre.'</center></td></tr>';

// Date

echo '<tr><td width="100%" bgcolor="#000000" class="style2">News ajoutée le '.$date.'</td>';

// Texte

echo '<tr><td colspan ="0" bgcolor="#000000" class="style9">'.nl2br($texte).'</td></tr></table><br>';

 }

?>