Text Formatted Code
global $_CONF, $_TABLES;
$retval = '';
$topics = DB_query ("SELECT `tid`, `topic` FROM {$_TABLES['topics']} order by `sortnum`");
$numtopics = DB_numRows ($topics);
for ($t = 0; $t < $numtopics; $t++) {
$B = DB_fetchArray ($topics);
$topicID = $B['tid'];
$topicname = $B['topic'];
$result = DB_query ("SELECT `sid`,`title` FROM {$_TABLES['stories']} WHERE tid = '$topicID'" . COM_getPermSQL ('AND') . " ORDER BY date DESC");
$num = DB_numRows ($result);
$retval .= '<b>' . $topicname . '</b><br>';
for ($i = 0; $i < $num; $i++) {
$A = DB_fetchArray ($result);
$retval .= '» <a href="' . $_CONF['site_url'] . '/article.php?story=' . $A['sid'] . '">' . stripslashes ($A['title']) . '</a><br>';
}
}