fedekiller

$q = mysql_query("SELECT $a.name AS cat_name, $a.id AS cat_id, $b.name AS forum_name, $b.id AS forum_id, $b.category AS forum_category, $b.description AS forum_description FROM $a INNER JOIN $b ON $b.category=$a.id ORDER BY cat_id ASC, forum_id ASC");$selected_categories = array();echo '<div id="all">';while($r = mysql_fetch_assoc($q)){	if(!in_array($r['cat_name'], $selected_categories))	{		echo '<div id="categoryname">		<a href="?nav=main&amp;cat='.$r['cat_id'].'">'.$r['cat_name'].'</a>		</div>		<div id="forumdesc">		<table width="99%" border="0">	    <tr>		<td width="40%">Forum Name</td>		<td width="20%" align="center">Topics</td>		<td width="20%" align="center">Replies</td>		<td width="19%"> Latest Post</td>		</tr>		</table>		</div>';	}	$topics = _count(prefix.'_posts', $r['forum_id']);	$replies = _count(prefix.'_replies', $r['forum_id']);	$title = getlastpost(prefix.'_posts', $r['forum_id']);	$desc = empty($r['forum_description']) ? null : '<br /><span class="forumdesc">'.$r['forum_description'].'</span>';	echo '<div id="forumname">	<table width="99%" border="0">	<tr>	<td width="40%"><a href="?nav=showforum&amp;id='.$r['cat_id'].'&amp;f='.$r['forum_id'].'">'.$r['forum_name'].'</a>'.$desc.'</td>	<td width="20%" align="center">'.$topics.'</td>	<td width="20%" align="center">'.$replies.'</td>	<td width="19%">'.$title.'</td>	</tr>	</table>	</div>';	$selected_categories[] = $r['cat_name'];}	echo '</div>';