Forums

<?php
// Retrieve News From Database
$db_news = $db->query('SELECT t.id, t.subject, t.forum_id,  p.topic_id, p.poster, p.poster_id, p.message, p.hide_smilies, p.posted FROM '.$db->prefix.'topics AS t INNER JOIN '.$db->prefix.'posts AS p ON t.id=p.topic_id AND p.posted=t.posted INNER JOIN '.$db->prefix.'users AS u ON u.id=p.poster_id INNER JOIN '.$db->prefix.'forums AS f ON f.id=t.forum_id WHERE t.forum_id='.$forum.' AND t.moved_to IS NULL AND f.redirect_url IS NULL ORDER BY t.posted DESC LIMIT '.$news) or error('Unable to fetch the news', __FILE__, __LINE__, $db->error());
                  
if ($db->num_rows($db_news))
{
    while($news = $db->fetch_assoc($db_news))
    {
        // Set Some Variables
        $message = parse_message($news['message'], $news['hide_smilies']);
        $subject = pun_htmlspecialchars($news['subject']);
        $poster = '<a href="profile.php?id='.$news['poster_id'].'">'.pun_htmlspecialchars($news['poster']).'</a>';
        $date_posted = format_time($news['posted'], true, 'jS M y');
        $news_id = intval($news['id']);
		
echo '<div id="content_main">
		<h3><span>'.$subject.'</span></h3>
		<p>'.$message.'</p>
		<p>Posted by '.$poster.' - '.$date_posted.'</p>
		<p><a href="forum/viewtopic.php?id='.$news_id.'">Comment</a></p>
	  </div>';

    }
}