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

fifa-in, Вот под вебку писал вывод на главную,
Может что и возьмешь от туда....

$total = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_news` WHERE `time` <= '" . time() . "'"), 0);
if ($total) {
    echo '<div class="phdr"><b>' . $lng['information'] . '</b></div>';
    $req = mysql_query("SELECT `id`, `refid`, `name`, `text`, `time` FROM `cms_news` WHERE `time` <= '" . time() . " ' ORDER BY `time`  DESC LIMIT 5");
    $i = 1;
    while (($row = mysql_fetch_assoc($req)) !== false) {
        echo $i % 2 ? '<div class="list1">' : '<div class="list2">';
        echo '<div class="tit_news"><a href="' . $set['homeurl'] . '/news/index.php?act=view&amp;id=' . $row['id'] . '">' . htmlentities($row['name'], ENT_QUOTES, 'UTF-8') . '</a></div>';
        echo '<div class="date_news">' . functions :: display_date($row['time']) . '<span class="comments_news"><a href="' . $set['homeurl'] . '/news/index.php?act=comments&amp;id=' . $row['id'] . '">Коммент&#160;(' . mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_news_comments` WHERE `refid`='" . $row['id'] . "'"), 0) . ')</a></span></div>';
        if (file_exists(H . 'files/news/web_news_' . $row['id'] . '.png') !== false)
            echo '<img style="float: left; margin: 5px 6px 2px 2px; border: 0px;" src="' . $set['homeurl'] . '/files/news/web_news_' . $row['id'] . '.png" width="120" height="100" alt="" />';
        $text = $row['text'];
        if (mb_strlen($text) > 400) {
            $str = mb_substr($text, 0, 400);
            $text = mb_substr($str, 0, mb_strrpos($str, ' ')) . ' [...]';
        }
        $text = functions :: checkout($text, 1, 1);
        $text = functions :: smileys($text);
        echo $text;
        echo '<div style="clear:both;"></div>';
        echo '</div>';
        ++$i;
    }
}