execute('SELECT p.id, p.title, p.seotitle, p.level, COUNT(v.postcat) as bobo FROM category p LEFT JOIN articles v ON v.postcat = p.id WHERE p.level = '.$DB->qstr('1').' GROUP BY p.id ORDER by title ASC');
if(!$rb)
print $DB->ErrorMsg();
else
while(!$rb->EOF) {
$category[] = $rb->fields;
$rb->MoveNext();
}
include ('includes/menu.php');
$smarty->display('links.php');
$smarty->display('footer.php');
?>
Top