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

# web_demon (01.10.2013 / 21:47)
$req = mysql_query("SELECT * FROM `forum` WHERE `type` = 't' AND `close`!='1' ORDER BY `time` DESC LIMIT 10");
while ($arr = mysql_fetch_array($req))
{
$q3 = mysql_query("sel

$req = mysql_query("SELECT `forum`.`text`, `newforum`.`text` as `razdel`, `rforum`.`text` as `rname`, COUNT(`messages`.`refid`) as `count` FROM `forum` LEFT JOIN `forum` as `newforum` ON `forum`.`refid`=`newforum`.`id` LEFT JOIN `forum` as `rforum` ON `newforum`.`refid`=`rforum`.`id` LEFT JOIN `forum` as `messages` ON `forum`.`id`=`messages`.`refid` WHERE `forum`.`type` = 't' AND `forum`.`close` != '1' GROUP BY `messages`.`refid` ORDER BY `forum`.`time` DESC LIMIT 10") or die(mysql_error());
while ($arr = mysql_fetch_array($req))
    {
echo 'Название темы: '.$arr['text'] . '<br />';
echo 'Название раздела: '.$arr['razdel'] . '<br />';
echo 'Название основного раздела: '.$arr['rname'] . '<br />';
echo 'Количество сообщений: '.$arr['count'] . '<br />';
}