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

$total_ads = mysql_result(mysql_query("SELECT COUNT(*) FROM `board_ads` WHERE `status` = '1'"), 0);
if ($total_ads)
{
    $limit = 3; // к-во выводимых записей
    $req = mysql_query("SELECT * FROM `board_ads` WHERE `status` = '1' ORDER BY `time` DESC LIMIT $limit");
    $i = 0;
    while ($res = mysql_fetch_assoc($req)) {
        echo '<div class="list' . ($i % 2 ? 1 : 2). '">'
            . functions::image('board.png') . '<a href="../board/?do=view&amp;id=' . $res['id'] . '">' . functions::checkout($res['name']) . '</a>';
        if ($res['img'] == 1) {
            echo '<div class="sub">';
            $req_i = mysql_query("SELECT * FROM `board_images` WHERE `ad_id` = " . $res['id'] . "");
            while ($res_i = mysql_fetch_assoc($req_i)) {
                echo '<a href="../files/board/' . $res_i['name'] . '.png"><img src="../files/board/small/' . $res_i['name'] . '.png" alt="' . $res_i['name'] . '"></a>&nbsp;';
            }
            echo '</div>';
        }
        echo '</div>';
        $i++;
    }
}

$total_ads = mysql_result(mysql_query("SELECT COUNT(*) FROM `board_ads` WHERE `status` = '1'"), 0);
if ($total_ads)
{
    $limit = 3; // к-во выводимых записей
    $req = mysql_query("SELECT * FROM `board_ads` WHERE `status` = '1' ORDER BY `time` DESC LIMIT $limit");
    $i = 0;
    while ($res = mysql_fetch_assoc($req)) {
        echo '<div class="list' . ($i % 2 ? 1 : 2). '">'
            . functions::image('board.png') . '<a href="../board/?do=view&amp;id=' . $res['id'] . '">' . functions::checkout($res['name']) . '</a>'
            . '</div>';
        $i++;
    }
}