openside("Statystyki kategorii newsów");

$result = dbquery("SELECT COUNT(news_id) AS news_count, news_cat FROM ".DB_NEWS." GROUP BY news_cat");

$news_count = array();

while($data = dbarray($result)) {

   $news_count[$data['news_cat']] = $data['news_count'];

}

$result = dbquery("SELECT news_cat_id, news_cat_name FROM ".DB_NEWS_CATS." ORDER BY news_cat_name ASC");

echo "<ul style='list-style:none;padding:0;margin:0;position:relative'>\n";

while($data = dbarray($result)) {

   echo "<li><a href='".BASEDIR."news_cats.php?cat_id=".$data['news_cat_id']."' title='Kategoria newsów: ".$data['news_cat_name']."'>".$data['news_cat_name']."</a> <span style='position:absolute;right:0;'>".(isset($news_count[$data['news_cat_id']]) ? $news_count[$data['news_cat_id']] : "0")." newsów</span></li>\n";

}

echo "</ul>\n";

unset($news_count);

closeside();