$req = mysql_query("SELECT * FROM `forum` WHERE `type` = 't' AND `close` != '1' ORDER BY `time` DESC LIMIT 5");
if (mysql_num_rows($req)) {
while ($res = mysql_fetch_assoc($req)) {
$q3 = mysql_query("select `id`, `refid`, `text` from `forum` where type='r' and id='" . $res['refid'] . "' LIMIT 1");
$razd = mysql_fetch_assoc($q3);
$q4 = mysql_query("select `id`, `refid`, `text` from `forum` where type='f' and id='" . $razd['refid'] . "' LIMIT 1");
$frm = mysql_fetch_assoc($q4);
$nikuser = mysql_query("SELECT `from`, `time` FROM `forum` WHERE `type` = 'm' AND `close` != '1' AND `refid` = '" . $res['id'] . "'ORDER BY `time` DESC");
$colmes1 = mysql_num_rows($nikuser);
$cpg = ceil($colmes1 / $kmess);
$nam = mysql_fetch_assoc($nikuser);
echo '<span class="color: white;"><img src="027.png" alt="-" /> <a href="forum/index.php?id='.$res['id'].'">'.$res['text'].'</a> ('.$res['from'].'/'.$nam['from'].')';
$colmes = mysql_query("SELECT * FROM `forum` WHERE `refid` = '" . $res['id'] . "' AND `type` = 'm'" . ($rights >= 7 ? '' : " AND `close` != '1'") . " ORDER BY `time` DESC");
echo '<a href="forum/index.php?id=' . $res['id'] . ($_SESSION['uppost'] ? '' : '&clip&page=' . $cpg) . '"> »</a>';
echo '<br /></span>';
}
надо этот код упростить, щас выводит так "название темы(SiТ/Мандарин) , а надо "название темы(Мандарин). Тоисть, только автор последнего моста... Удалял строчку .$res['from']. но не помогает!