openside("name");

setlocale(LC_TIME, 'pl_PL', 'pl', 'Polish_Poland.28592');

$wynik = dbquery("SELECT COUNT(news_cat) AS count_cat, news_cat_name

 FROM ".DB_NEWS." n LEFT JOIN ".DB_NEWS_CATS." c ON (n.news_cat=c.news_cat_id)

 WHERE news_cat !=0 AND

 ".groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().") AND news_draft='0'

AND MONTH(FROM_UNIXTIME(news_datestamp)) = MONTH(DATE_SUB(CURDATE(), INTERVAL 1 MONTH))

AND 

YEAR(FROM_UNIXTIME(news_datestamp)) = YEAR(DATE_SUB(CURDATE(), INTERVAL 1 MONTH))

  GROUP BY news_cat ORDER BY news_cat_name");    

echo "<table border='0' width='100%' class='small'>";

if(dbrows($wynik) > 0) {  

echo "<tr><td class='small' colspan='2'>Podsumowanie za miesiąc: ".strftime('%B', strtotime("- 1 month"))."</td></tr>";

$razem = 0;

while($r = dbarray($wynik))    

{

$razem = $razem + $r['count_cat'];

echo "<tr><td class='small'>".$r['news_cat_name']."</td><td align='right' class='small'>".number_format($r['count_cat'])."</td></tr>";

}

echo "<tr><td class='small' colspan='2'>Razem: ".number_format($razem)."</td></tr>";



} else {

echo "<tr><td class='small' colspan='2'>W miesiącu ".strftime('%B', strtotime("- 1 month"))." nie dodano żadnych newsów.</td></tr>";

}

echo "</table>";

closeside();