assign("totallast",$total,true); $last=""; $query=mysql_query("SELECT * FROM habbophp_help_articles ORDER BY id DESC"); while($row=mysql_fetch_assoc($query)) { $last[] = $row ; } $tpl->assign("last",$last,true); //Category $category=""; $query=mysql_query("SELECT * FROM habbophp_help_category ORDER BY id DESC"); while($row=mysql_fetch_assoc($query)) { $queryee=mysql_query("SELECT * FROM habbophp_help_articles WHERE cid=".$row['id']." ORDER BY title ASC"); $total=mysql_num_rows($queryee); $category.='

'.$row['value'].' ('.$total.')

'; } $tpl->assign("category",$category,true); $tpl->display('help_header.tpl'); $tpl->display('help_index.tpl'); $tpl->display('help_footer.tpl'); ?>