<?php 

require("/home/usr1/www.animeboards.net/htdocs/forums/admin/config.php"); 
$db=mysql_connect($servername,$dbusername,$dbpassword); 
mysql_select_db($dbname); 
$query = "SELECT * FROM category where categoryid=1 or categoryid=2 or categoryid=3 or categoryid=4 or categoryid=5 or categoryid=6 or categoryid=7 or categoryid=8 or categoryid=9 or categoryid=10 or categoryid=11 ORDER BY displayorder, title ASC"; 
$resultlatest = mysql_query($query,$db); 
while ($latest_array = mysql_fetch_array($resultlatest)) { 
$countid = $latest_array[categoryid] ; 
$q1 = "select * from forum where categoryid=$countid"; 
$howmany = mysql_query($q1,$db); 
$counter="0"; 
while ($count_array = mysql_fetch_array($howmany)) { 
$counter = $counter + $count_array[threadcount]; 
} 
echo "<FONT SIZE=\"1\" FACE=\"Arial\"> ? 
<A HREF=\"http://animeboards.net/forums/index.php?categoryid=$latest_array[categoryid]\">$latest_array[title]</A> ($counter)</FONT><BR>"; 
} 

?>