SkoRoST, вывод последних тем с постами на главную
$req = mysql_query("SELECT `id`,`text`, `from` FROM `forum` where type='t' ORDER BY time DESC LIMIT 5; ");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);echo'<div class="menu">';echo "<a href='forum/index.php?id=".$arr['id']."'>$arr[text]</a>".$nam['text']."--".$nam['from']."";$vrp = $nam['time'] + $set_user['sdvig'] * 3600; echo ' <font color="#777777">(' . date("d.m.y / H:i", $vrp) . ")</font>";echo'</div>';}