Вывод на главную!

biluy3 (27.03.2012/08:59)
Нужен код который выводит на
главную раздел из Загруз
центра, например Картинки, и все остальные,
чтобы вместе с счетчиком...ЗЦ от Flyself'a ..

$req = mysql_query("SELECT `id`,`text`, `from` FROM `forum` where type='t' ORDER BY time DESC LIMIT 3; ");
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="menu"> ';
echo " » <a href='forum/index.php?id=".$arr['id']."'>$arr[text]</a> [$colmes1]";
echo'</div>';
}

// Значки
$icons = array(
	($np ? (!$res['vip'] ? '<img src="../theme/' . $set_user['skin'] . '/images/op.gif" alt=""/>' : '') : '<img src="../theme/' . $set_user['skin'] . '/images/np.gif" alt=""/>'),
	($res['vip'] ? '<img src="../theme/' . $set_user['skin'] . '/images/pt.gif" alt=""/>' : ''),
	($res['realid'] ? '<img src="../theme/' . $set_user['skin'] . '/images/rate.gif" alt=""/>' : ''),
	($res['edit'] ? '<img src="../theme/' . $set_user['skin'] . '/images/tz.gif" alt=""/>' : '')
);
$req = mysql_query("SELECT `id`,`text`, `from` FROM `forum` where type='t' ORDER BY time DESC LIMIT 3; ");
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="menu"> ';
	echo functions::display_menu($icons, '&#160;', '&#160;');
	echo '<a href="forum/index.php?id='.$arr['id'].'">'.$arr['text'].'</a> ['.$colmes1.']';
	echo'</div>';
}

LYCUK (02.04.2012/14:00)
venom, ну так давай код рабочий гг

$lim_top = '5'; //5/Меняем на свое количество ...... гг
$req = mysql_query("SELECT * FROM `forum` where type='t' ORDER BY time DESC LIMIT $lim_top");
$i = 0;
while ($res = mysql_fetch_array($req)){
	$nikuser = mysql_query("SELECT `from` FROM `forum` WHERE `type` = 'm' AND `close` != '1' AND `refid` = '" . $res['id'] . "' ORDER BY `time` DESC LIMIT 1");
	$nam = mysql_fetch_assoc($nikuser);
	$colmes = mysql_query("SELECT COUNT(*) FROM `forum` WHERE `type`='m' AND `refid`='" . $res['id'] . "'" . ($rights >= 7 ? '' : " AND `close` != '1'"));
	$colmes1 = mysql_result($colmes, 0);
	// Значки
	$icons = array(
		($np ? (!$res['vip'] ? '<img src="../theme/' . $set_user['skin'] . '/images/op.gif" alt=""/>' : '') : '<img src="../theme/' . $set_user['skin'] . '/images/np.gif" alt=""/>'),
		($res['vip'] ? '<img src="../theme/' . $set_user['skin'] . '/images/pt.gif" alt=""/>' : ''),
		($res['realid'] ? '<img src="../theme/' . $set_user['skin'] . '/images/rate.gif" alt=""/>' : ''),
		($res['edit'] ? '<img src="../theme/' . $set_user['skin'] . '/images/tz.gif" alt=""/>' : '')
	);
	echo'<div class="menu"> ';
	echo functions::display_menu($icons, '&#160;', '&#160;');
	echo '<a href="forum/index.php?id='.$res['id'].'">'.$res['text'].'</a> ['.$colmes1.']';
	echo '<div class="sub">';
	echo $res['from'];
	if (!empty($nam['from'])) {
		echo '&#160;/&#160;' . $nam['from'];
	}
	echo ' <span class="gray">(' . functions::display_date($res['time']) . ')</span></div>';
	echo'</div>';
	++$i;
}