[Mutt]

here, use this. you should be able to modify it to build the table. it's from the any forum news hack

PHP Code:

/ ###################### Start Active Topics #######################

$getheadssql=$DB_site->query("SELECT threadid,thread.title as title,lastpost,forumid,open,replycount,dateline,views,visible,thread.iconid
    ".iif($foruminfo[allowicons],',icon.title as icontitle,icon.iconpath','')."
    FROM thread
    ".iif($foruminfo[allowicons],'LEFT JOIN icon ON (icon.iconid = thread.iconid)','')."
    WHERE visible=1 AND open!=10
    ORDER BY lastpost DESC LIMIT 0,$maxactivetopics
    ");
while ($getheads=$DB_site->fetch_array($getheadssql)) {
  $glforumid=$getheads[forumid];
  $getforumnamesql=$DB_site->query("SELECT forumid,title FROM forum WHERE forumid=$glforumid");
  $getforumname=$DB_site->fetch_array($getforumnamesql);

      if (!$foruminfo[allowicons] or $getheads[iconid]==0) {
        if ($showdeficon) {
            $glicon='<img src="images/icons/icon1.gif"  border="0" alt="">';
          } else {
          $glicon="&nbsp;";
        }
      } else {
         $glicon="<img src=\"$getheads[iconpath]\" alt=\"$getheads[icontitle]\" width=\"15\" height=\"15\" border=\"0\">";
      }

      if ($foruminfo[allowicons] and $getheads[pollid]!=0) {
        $glicon='<img src="{imagesfolder}/poll.gif" alt="Poll" width="15" height="15" border="0">';
      }
  
  $glthreadid=$getheads[threadid];
  $gltitle=$getheads[title];
  $glforumname=$getforumname[title];
  $glreplycount=$getheads[replycount];
  $glviewcount=$getheads[views];
  $gldateline=vbdate($dateformat,$getheads[dateline]);

    if ($bgclass == "alt2") {
        $backcolor="{firstaltcolor}";
        $bgclass = "alt1";
    } else {
        $backcolor="{secondaltcolor}";
        $bgclass = "alt2";
    }  
  
  eval("\$getheadsbits .= \"".gettemplate("main_getheadsbit")."\";");
}