LIMIT noget til noget andet

LIMIT startindex,antalposter.

F.eks.

LIMIT 10,10
vil vise posterne fra nummer 10 -> 19

et eksempel:
if (!isset($_GET[current_page])) {
    $current_page = 0;
}
else {
    $current page = $_GET[current_page];
}
if (!isset($_GET[messages_per_page])) {
    $messages_per_page = 3;
}
else {
    $messages_per_page = $_GET[messages_per_page];
}
$total_posts = mysql_result(mysql_query("SELECT COUNT(*) FROM news"),0) or die(mysql_error());
$total_pages = (int) ($total_posts / $messages_per_page]);



$navigation_text = "";
if ($current_page > 0) {
    $navigation_text .= "<a href=\"$_SERVER[PHP_SELF]?current_page=".($current_page-1)."&messages_per_page=$messages_per_page\" title=\"Previous page\">&#171;</a>&nbsp;&nbsp;";
}
else {
    $navigation_text .= "&#171;&nbsp;&nbsp;";
}

for ($i=0;$i<=$total_pages;$i++) {
    if ($current_page] != $i) {
        $navigation_text .= "<a href=\"$_SERVER[PHP_SELF]?current_page=".($i)."&messages_per_page=$messages_per_page\" title=\"Page ". ($i+1) ."\">". ($i+1) ."</a>&nbsp;&nbsp;";
    }
    else {
        $navigation_text] .= "<b>". ($i+1) ."</b>&nbsp;&nbsp;";
    }
}

if ($current_page < $total_pages) {
    $navigation_text .= "<a href=\"$_SERVER[PHP_SELF]?current_page=".($current_page+1)."&messages_per_page=$messages_per_page\" title=\"Next page\">&#187;</a>";
}
else {
    $navigation_text .= "&#187;";
}



$query = mysql_query("SELECT * FROM news ORDER BY id DESC LIMIT  ".($current_page * $messages_per_page).", $messages_per_page");


?>
så har du så et resultset som du så kan bruge til hvad du vil
variablen $navigation_text udskriver du blot hvor du nu ønsker dette

<? echo $navigation_text; ?>