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

<?php

$limit = 3;
 
$total = mysql_result(mysql_query('SELECT COUNT(*) FROM `library_texts` WHERE `premod`=1'), 0);

if ($total) {
    $sql = mysql_query("
        SELECT 
            `id`,
            `name`,
            `time`,
            `count_views`,
            `count_comments`,
            `comments`
        FROM
            `library_texts`
        WHERE
            `premod` = 1 
        ORDER BY `id` DESC LIMIT ". $limit
    );

    $i = 0;
    
    while ($row = mysql_fetch_assoc($sql)) {
        // Описание к статье
        $obj = new Hashtags($row['id']);
        $rate = new Rating($row['id']);

        echo '<div class="list'. (++$i % 2 ? 2 : 1) . '"><table class="desc">'.
            // Тэги
            ($obj->get_all_stat_tags() 
                ? '<tr><td class="caption">'. $lng_lib['tags'] .':</td><td>'. 
                $obj->get_all_stat_tags(1) .'</td></tr>' : '')

            // Рейтинг
            . '<tr>'
            . '<td class="caption">'. $lng['rating'] .':</td>'
            . '<td>'. $rate->view_rate() .'</td>'
            . '</tr></table></div>';
    }
} else {
    echo '<div class="menu">'. $lng['list_empty'] .'</div>';
}