openside("Kategorie Download");

$wynik = dbquery("SELECT c.*, (SELECT COUNT(download_id) FROM ".$db_prefix."downloads a WHERE (c.download_cat_id=a.download_cat)) AS ile

FROM ".$db_prefix."download_cats c 

WHERE ".groupaccess('download_cat_access')." AND download_cat_id='2' ORDER BY ile DESC");

if(dbrows($wynik) > 0) {

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

while($r = dbarray($wynik))    

{

echo "<tr><td>".$r['download_cat_name']."</td><td align='right'>".number_format($r['ile'])."</td></tr>";  

}

echo "</table>";

}

closeside();