Просмотр поста

Ребята помогите с выводом тем форума )
вот код

$req = mysql_query("SELECT `id`,`text`, `from` FROM `forum` where type='t' ORDER BY time DESC LIMIT 3; ");
while ($arr = mysql_fetch_array($req)){
$nikuser = mysql_query("SELECT `from`,`time`,`text` FROM `forum` WHERE `type` = 'm' AND `close` != '1' AND `refid` = '" . $arr['id'] . "'ORDER BY time DESC LIMIT 1;");
$nam = mysql_fetch_array($nikuser);
$colmes = mysql_query("SELECT COUNT(*) FROM `forum` WHERE `type`='m' AND `refid`='" . $arr['id'] . "'" . ($rights >= 7 ? '' : " AND `close` != '1'"));
$colmes1 = mysql_result($colmes, 0);
echo'<div class="menu"> ';
echo " » <a href='forum/index.php?id=".$arr['id']."'>$arr[text]</a> [$colmes1]";
echo'</div>';
}