<?php
include "connect.php";
$page = (!isset($_GET['page'])) ? 1 : $_GET['page'];
//aantal records per pagina
$rest = mysql_query("SELECT * FROM reacties WHERE `sid`='{$_GET['sid']}'");
$max = mysql_num_rows($rest);
$start = ($max * $page) - $max;
//hier je gegevens van je mysql ophalen
while($var = mysql_fetch_array(mysql_query("SELECT * FROM reacties WHERE `sid`='{$_GET['sid']}' ORDER BY id DESC LIMIT " . $start . ", " . $max . ""))) {
    echo $var['inhoud'];
}
//hier aan jou mysql gegevens aanpassen
$rows = mysql_result(mysql_query("SELECT COUNT(id) FROM reacties WHERE `sid`='{$_GET['sid']}'ORDER BY id"),0);
$pages = ceil($rows / $max);
if ($page > 1) {
    $previous = $page - 1;
    echo "<a href=\"" . $_SERVER['PHP_SELF'] . "?page=" . $previous . "\"><<</a>&nbsp";
}
    for ($i = 1; $i <= $pages; $i++) {
        if ($page == $i) {
            if ($i == $pages) {
                echo "<b>" . $i . "</b>&nbsp";
            } else {
                echo "<b>" . $i . "</b>,&nbsp";
            }
        } else {
            if ($i == $pages) {
                echo "<a href=\"" . $_SERVER['PHP_SELF'] . "?page=" . $i . "\">" . $i . "</a>&nbsp";
        } else {
            echo "<a href=\"" . $_SERVER['PHP_SELF'] . "?page=" . $i . "\">" . $i . "</a>,&nbsp";
        } 
    }
}
if ($page < $pages) {
    $next = $page + 1;
    echo "<a href=\"" . $_SERVER['PHP_SELF'] . "?page=" . $next . "\">>></a>";
}
?>