prepare(); $result = miraquery("SELECT id,short,name FROM sections WHERE cat_status=1 AND status=1 ORDER BY name"); while ($row = mira_fetch_array($result)) { $tpl->newBlock(CATS); $tpl->assign("CATLINK", linkback($row[id],$row[short])); $tpl->assign("CATEGORY", $row[name]); $articles = miraquery(" SELECT m.id,m.title,m.article_name FROM mainlist AS m, mainlist_cats AS c WHERE m.id=c.id AND c.cat=".intval($row[id])." AND m.status>=2 ORDER BY m.title"); while ($row2 = mira_fetch_array($articles)) { $tpl->newBlock(ARTICLES); $tpl->assign("LINK", articlelink($row2[id],$row2[article_name])); $tpl->assign("TITLE", $row2[title]); } } $tpl->printtoScreen(); ?>