$result = mysql_query("SELECT * FROM teensay_vbboardscurrent.thread WHERE forumid!=59 AND forumid!=62 ORDER BY 'threadid' DES$ $count = 0; while ($row = mysql_fetch_array($result)) { $count++; ( (is_float($count/2)) ? $color = '#E8F2FF' : $color='#C1DCFF' ); $tpl->assign('ht_bg', $color); $tpl->assign('ht_id', $row['threadid']); $tpl->assign('ht_title', $row['title']); $tpl->assign('ht_name', $row['lastposter']); $tpl->assign('ht_date', date("d.m.y h:i:s",$row['lastpost'])); $hottopics .= $tpl->parse($templatepath.'/home/hottopics_template.html'); } $ch .= '</table>';