$result = dbquery("SELECT faq_cat_id, faq_cat_name, (SELECT COUNT(faq_id) FROM ".DB_FAQS." c2 WHERE (c1.faq_cat_id=c2.faq_cat_id)) AS num FROM ".DB_FAQ_CATS." c1 ORDER BY faq_cat_name"); if(dbrows($result) > 0) { $sum = 0; echo ""; while($data = dbarray($result)) { echo ""; $sum += $data['num']; } echo ""; echo "
".THEME_BULLET." ".$data['faq_cat_name']."".number_format($data['num'])."
Razem: ".number_format($sum)."
"; }