<?

$reponse = mysql_query("SELECT * FROM news ORDER BY id DESC");



while ($news = mysql_fetch_array($reponse))

{

function dateUsToFr ($date) {

    sscanf($datetime, "%4s-%2s-%2s %2s:%2s:%2s", &$y, &$mo, &$d, &$h, &$mi, &$s);

    return $d.'-'.$mo.'-'.$y.' '.$h.':'.$mi.':'.$s;

}



$date=$news['date'];

$date=dateUsToFr($date);

?>

<div align="left"><b>>> <? echo $news['titre']; ?></b><br><br>

<? echo $news['contenu']; ?><br></p>

<p align="right"><i>Posté par <b><a href="mailto:ftptrashersite@free.fr"><? echo $news['auteur']; ?></a></b> le <? echo $news['date']; ?></p></i></div>

<?

}

mysql_close();

?>