By Sam308 on
How Would You Display Particular Forum Topics in a List for Drupal 6.x?
Assuming I have a total of 30 forums, and the following PHP code will display all the toipics within a particular forum (forum #1 in this example), how would you modify the code to display the forum topics within forums 1, 3, 5, 7, and 9?
<?php
$listlength="10";
$forum_term_id = 1;
$sql = "SELECT n.nid, n.title, l.last_comment_timestamp, l.comment_count FROM {node} n INNER JOIN {term_node} t ON n.nid = t.nid INNER JOIN {node_comment_statistics} l ON n.nid = l.nid WHERE n.status = 1 AND t.tid = $forum_term_id AND n.type='forum' ORDER BY l.last_comment_timestamp DESC";
$sql = db_rewrite_sql($sql);
$content = node_title_list(db_query_range($sql, 0, $listlength), t('Active forum topics:'));
if ($content) {
$content .= '<div class="more-link">'. l(t('more'), 'forum', array('title' => t('Read the latest forum topics.'))) .'</div>';
}
print $content;
?>
In my particular case, the "more" link at the end of the list is not required. All I need is an outputted bullet list of the topics within forums 1, 3, 5, 7, and 9.
It may be possible to achieve the output using the Views module, but I rather just use a PHP snipplet.
Thanks in advance,
Sam308
