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

<?php $req = mysql_query ( "SELECT `id`,`text`, `from` FROM `forum` where type='t' ORDER BY time DESC LIMIT 4; " ); 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="formenu">' ; echo "<a href='forum/index.php?id=" . $arr [ 'id' ]. "'>$arr[text]</a>[$colmes1]--" . $nam [ 'from' ]. "" ; $vrp = $nam [ 'time' ] + $set_user [ 'sdvig' ] * 3600 ; echo '<font color="#777777">(' . date ( "d.m.y / H:i" , $vrp ) . ")</font>" ; echo '</div>' ; }?>