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

$req = mysql_query("SELECT * FROM `forum` WHERE `type` = 't' AND `close`!='1' ORDER BY `time` DESC LIMIT5");    while ($arr = mysql_fetch_array($req)) {        $q3 = mysql_query("select `id`, `refid`, `text` from `forum` where type='r' and id='" . $arr['refid'] . "'");        $razd = mysql_fetch_array($q3);$q4 = mysql_query("select `id`, `refid`, `text` from `forum` where type='f' and id='" . $razd['refid'] . "'");        $frm = mysql_fetch_array($q4);        $nikuser = mysql_query("SELECT `from`, `time` FROM `forum` WHERE `type` = 'm' AND `close` != '1' AND `refid` = '" . $arr['id'] . "'ORDER BY time DESC");        $colmes1 = mysql_num_rows($nikuser);        $cpg = ceil($colmes1 / $kmess);        $nam = mysql_fetch_array($nikuser);        echo is_integer($i / 2) ? '<div class="list1"><div>' : '<div class="list2"><div>';        echo '&nbsp;&#187;&#187; <a href="index.php?id=' . $arr['id'] . ($cpg > 1 && $_SESSION['uppost'] ? '&amp;clip&amp;page=' . $cpg : '') . '">' . $arr['text'] . '</a>&nbsp;[' . $colmes1 . ']<div class="sub">';        if ($cpg > 1)            echo '&nbsp;<a href="index.php?id=' . $arr['id'] . ($_SESSION['uppost'] ? '' : '&amp;clip&amp;page=' . $cpg) . '">&gt;&gt;</a>';        echo $arr['from'];        if (!empty ($nam['from'])) {            echo '&nbsp;/&nbsp;' . $nam['from'];        }        echo ' <font color="#777777">' . date("d.m.y / H:i", $nam['time']) . '</font>';        echo '</div></div></div>';        $i++;    }