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

$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). '">'
            . '<img src="../images/board.png" align="middle" alt="ad">&nbsp;<a href="../board/?do=view&amp;id=' . $res['id'] . '">' . functions::checkout($res['name']) . '</a>'
            . '</div>';
        $i++;
    }
}