Rewriter l'affichage des derniers messages d'un forum

de **gcvoiron** » Ven Nov 24, 2006 12:19 am

Bonjour,

J'utilise ce code pour afficher les derniers messages de mon forum sur les pages de mon site :

Code: Tout sélectionner: <?php require_once("config.php"); $dbh = mysql_connect($db_host, $db_login, $db_pass); $db_name = mysql_select_db($db_name); $sql = "SELECT `topic_id`, `topic_title`, `topic_time`, `forum_name`, forum_forums.forum_id FROM `forum_topics`, `forum_forums` WHERE forum_forums.forum_id = forum_topics.forum_id AND forum_forums.forum_id = '39' AND `auth_view` = '0' AND forum_forums.forum_id != '8' ORDER BY `topic_time` DESC LIMIT 0,10"; $r_topics = mysql_query($sql) or die(mysql_error()); while ($aff_forums = mysql_fetch_array($r_topics)) { $id = $aff_forums['topic_id']; $f_id = $aff_forums['forum_id']; $title = $aff_forums['topic_title']; $f_title = $aff_forums['forum_name']; $time = $aff_forums['topic_time']; $time = date("d/m/y", $time); echo " <TR> <TD><center><span class=texte>" . $time . "</span></center></TD> <TD><center><div align=left><span class=texte><a href=\"http://www.benefweb.com/forum/viewtopic.php?t=" . $id . "\">" . $title . "</span></a><br /></div></center></TD> </TR>"; } mysql_close($dbh); ?>

Comment le rewriter?

Merci.