| |
| |
|
|
|
|
| |
|
| |
|
| :: |
| Auteur |
Message |
gcvoiron
PR1
Inscrit le: 08 Juin 2006
Messages: 120
|
 Posté le: Ven Nov 24, 2006 12:19 am Sujet du message: Rewriter l'affichage des derniers messages d'un forum |
|
|
Bonjour,
J'utilise ce code pour afficher les derniers messages de mon forum sur les pages de mon site :
| Code: | <?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. |
_________________
Gagnez argent et cadeaux avec Internet sur www.benefweb.com |
|
| Revenir en haut de page |
|
 |
|
|
dcz
Administrateur - Site Admin
Inscrit le: 28 Avr 2006
Messages: 15135
|
|
| Revenir en haut de page |
|
|
gcvoiron
PR1
Inscrit le: 08 Juin 2006
Messages: 120
|
| Posté le: Ven Nov 24, 2006 5:12 pm Sujet du message: Re: Rewriter l'affichage des derniers messages d'un forum |
|
|
| Ok, merci. |
_________________
Gagnez argent et cadeaux avec Internet sur www.benefweb.com |
|
| Revenir en haut de page |
|
|
|
| Navigation |
Autres sujets de discussion |
|
|
|
|
|
|
|
| |
|
|
|
|
| |
|
|
|
|
| |
