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

Here is my code for last themes

$kmessreq= 6;
$startreq = isset($_REQUEST['page']) ? $page * $kmessreq - $kmessreq : (isset($_GET['start']) ? abs(intval($_GET['start'])) : 0); 
$total = mysql_result(mysql_query("SELECT COUNT(*) FROM `forum` WHERE `type` = 't' and `kedit`='0' AND `close`!='1' "), 0); 
$req = mysql_query("SELECT * FROM `forum` WHERE `type` = 't' and kedit='0' AND `close`!='1' ORDER BY `time` DESC LIMIT $startreq, $kmessreq"); 
while ($arr = mysql_fetch_assoc($req)) { 
$nikuser = mysql_query("SELECT `from`,`id`, `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_assoc($nikuser);
echo '<div class="teme">';

echo '</b>';
echo '&nbsp;<a href="forum/index.php?id=' . $arr['id'] . '">' . $arr['text'] . '</a> [' . $colmes1 . ']';
if ($cpg > 1)
echo '<a href="forum/index.php?id=' . $arr['id'] . '&amp;page=' . $cpg . '">&gt;&gt;</a>';
if ($colmes1 > 1){
echo ' <font color="red">~ '.$nam['from'].' </font>';
}else
echo ' <font color="red">~ '.$arr['from'].'</font>';
echo '<br/><span class="gray">(' . functions::display_date($arr['time']) . ')</span> | <span class="gray">Pregleda: ' . $arr['view'] . '</span>';


echo '</div>';
}