Witze
"; $a=mysql_query("SELECT w2.id, COUNT( w1.kat ) AS gesamtkat, w2.kat FROM funkoenig_witze w1 INNER JOIN funkoenig_witzekat w2 ON w1.kat = w2.id GROUP BY w2.kat") or die(mysql_error()); $b=mysql_query("SELECT count(id) from funkoenig_witze"); list($gesamtmenge)=mysql_fetch_row($b); //echo ""; while($kat=mysql_fetch_array($a)){ echo "
\">$kat[kat] ($kat[gesamtkat])
"; } echo "



"; include('sidebar_right.php'); include('footer.php');?>