Вывод из базы вывод задом наперед

SELECT ...
ORDER BY `field_name` DESC

SELECT ...
LIMIT 0, 3

-- Второй вариант будет:
LIMIT 3, 3

echo '<a class="entryReadAllLink" href="allannouncement.php?code='.$myannouncements[0].'" onclick="$increm = mysql_query("INSERT INTO announcement (views) values('.$myview.' = '.$myannouncements[6].' + 1);");>Читати далі >></a>';

UPDATE `announcement`
SET `views` = `views` + 1
WHERE `id` = 24;

include ("codes/db_connect.php");
              // Считаем количество строк в таблице и делим на заданное. Получится количество страниц
              $res = mysql_query("SELECT COUNT(*) AS `cnt` FROM announcement", $db);  
            $c = mysql_result($res, 0) / $num;
            $count = ceil ($c);
            // Формируем меню
               for($i = 1; $i <= $count; $i++)
               {
                   echo '<a href="announcement.php?page='. $i .'">'. $i .'</a>';
               }
               mysql_close ($db);

$num = 3;
          // Принимаем номер требуемой страницы      
        $page = !empty($_GET['page']) ? (int)$_GET['page'] : 1;
          include ("codes/db_connect.php");
          $exec = ($page - 1) * $num;
        $announcements = mysql_query ("SELECT * FROM announcement ORDER BY `code` DESC LIMIT".$exec, $db);
        while ($myannouncements = mysql_fetch_array ($announcements))

  
            $res = mysql_query("SELECT COUNT(*) AS `cnt` FROM announcement", $db);  
            $c = mysql_result($res, 0) / $num;
            $count = ceil ($c);
            // Формируем меню
            for($i = 1; $i <= $count; $i++)
            {
                   echo '<a href="announcement.php?page='. $i .'">'. $i .'</a>';
            }

            $res = mysql_query("SELECT COUNT(*) AS `cnt` FROM announcement", $db);  
            $c = mysql_result($res, 0) / $num;
            $count = ceil ($c);
            // Формируем меню 
            function createMenu($count, $page)
            {   
                $menu = '';    
                for($i = 1; $i <= $count; $i++)
                {
                   if($i == $page)
                       $menu .= '<b>'. $i .'</b>';
                   else
                       $menu .= '<a href="announcement.php?page='. $i .'">'. $i .'</a> ';           
                }
                return $menu;
            }

                $num = 3;
          $res = mysql_query("SELECT COUNT(*) AS `cnt` FROM announcement", $db);  
           $aCount = mysql_fetch_assoc($res);
           //Узнаем количество необходимых страниц
           $iPages = ceil($aCount['count'] / $num);
           //Проверка текущей страницы
           $page = (isset($_GET['page']) && $_GET['page'] <= $aCount['count']) ? $_GET['page'] : 1;
           //Определения нужного текста для вывода
           $iOffsetLimit = ($page - 1) * $num;
        $iStart = ($page > 5) ? $page - 4 : 1;
          
          $announcements = mysql_query ('SELECT * FROM announcement ORDER BY `code` DESC LIMIT ' . $iOffsetLimit . ',' . $num, $db) or exit(mysql_error());
        while ($myannouncements = mysql_fetch_array ($announcements))
        {
            echo '<table border="0" cellspacing="0" cellpadding="0" width="100%">';
            echo '<tbody>';
            echo '<tr>';
            echo '<td style="padding:3px">';
            echo '<div style="text-align:left" class="eTitle"><a href="allannouncement.php?code='.$myannouncements[0].'">';
            echo $myannouncements[1];
            echo '</a>';
            echo '</div>';
            echo '<div style="text-align:left; clear:both; padding-top:2px; padding-bottom:2px" class="eMassage">';
            echo $myannouncements[2];
            echo '<p align="center"><img src="';
            echo 'image/announcement/';
            echo $myannouncements[4];
            echo '" /></p> ';
            echo '</div>';
            echo ' <div style="clear:both;" class="eDetails">';
            echo '<div style="float:right">';
            echo '<span class="entryReadAll">';
            echo '<a class="entryReadAllLink" href="allannouncement.php?code='.$myannouncements[0].'">Читати далі >></a>';
            echo '</span>';
            echo '</div>';
            echo 'Переглядів:&nbsp';
            echo $myannouncements[5];
            echo '&nbsp&diams;&nbsp';
            echo 'Додав:&nbsp';
            echo $myannouncements[6];
            echo '&nbsp&diams;&nbsp';
            echo 'Дата:&nbsp<span title="18:21">';
            echo $myannouncements[7];
            echo '</span>';
            echo '</div>';
            echo '</td>';
            echo '</tr>';
            echo '</tbody>';
            echo '</table>';
            echo '<br />';
           }
           
           //вывод пагинатора
           echo '<div class="catPages" align="center" style="clear:both" id="pagesBlock">';  
        if ($iPages > 1) 
        {
            echo '<div>Страницы: ';
            for ($i = $iStart; $i <= $iPages; $i++) 
            {
                if ($page > 4 && $i == $page - 4)
                {
                    echo '<a href="announcement?page=' . $i . '">...</a>' . "\n";
                    continue;
                }
                    if ($i > $page + 3) 
                    {
                        echo '<a href="announcement?page=' . $i . '">...</a>' . "\n";
                        break;
                    }
                    if ($i == $page) 
                    {
                        echo ' <b> ' . $i . ' </b> ' . "\n";
                    } 
                    else 
                    {
                        echo '<a href="announcement?page=' . $i . '">' . $i . '</a>' . "\n";
                    }
               }
            echo '</div>' . "\n";
        }
           mysql_close ($db);

$num = 3;

$page = (isset($_GET['page']) && $_GET['page'] <= $aCount['count']) ? $_GET['page'] : 1;
$iOffsetLimit = ($page - 1) * $num;

$announcements = mysql_query ('SELECT * FROM announcement ORDER BY `code` DESC LIMIT ' . $iOffsetLimit . ',' . $num, $db) or exit(mysql_error());

SELECT * FROM announcement ORDER BY `code` DESC LIMIT 0