<?php
error_reporting(E_ALL);
ini_set('display_errors', 1);
ini_set('mysql.trace_mode', 0);

if (!isset($_POST["kategorie"])) {
    $_POST["kategorie"] = '';
}



$items_per_page = 5;
$page = isset($_POST['page']) ? abs((int)$_POST['page']) : 0;
$offset = $page * $items_per_page;

$mysql = mysql_connect("Provider","user","Passwort") or die(mysql_error());
mysql_select_db("datenbank", $mysql) or die(mysql_error());

    $sql = "SELECT
                SQL_CALC_FOUND_ROWS
                sprueche.autor AS spruecheid,
                sprueche.kategorie,
                sprueche.spruch,
                sprueche.spruch_notiz,
                sprueche.eingetragen_am,
                autor.autor_id AS autorid,
                autor.vorname,
                autor.nachname,
                autor.wikipedia,
                user.user_id AS userid,
                user.nutzername,
                user.email,
                user.website
            FROM
                sprueche
            INNER JOIN
                autor
            ON
                sprueche.autor = autor.autor_id
            INNER JOIN
                user
            ON
                sprueche.user = user.user_id
            WHERE
                sprueche.kategorie like '%" . mysql_real_escape_string($_POST["kategorie"], $mysql) . "%'
            ORDER BY
                sprueche.eingetragen_am DESC
            LIMIT
            $offset,$items_per_page";

$res = mysql_query($sql, $mysql) or die(mysql_error());
while ( false!==($dsatz=mysql_fetch_array($res, MYSQL_ASSOC)) ) 
{
     echo "<small><small>";
     echo "Beitrag von ". $dsatz["nutzername"] ." | ";
     if ($dsatz["email"] != "")
      {
       echo "<a href=mailto:". $dsatz["email"] ."><small>". $dsatz["email"] ."</small></a>";
       echo " | ";
      }
     if ($dsatz["website"] != "")
      {
       echo "<a href=\"http://". $dsatz["website"] ."\" target=_blank><small>". $dsatz["website"] ."</small></a>";
       echo " | ";
      }
     echo "eingetragen am ". $dsatz["eingetragen_am"] ."";
     echo "</small></small>";
     echo "<br>";
     echo nl2br("<big>". $dsatz["spruch"] ."</big>");
     if ($dsatz["spruch_notiz"] != "")
      {
       echo "<br>";
       echo "<small><small>";
       echo "(". $dsatz["spruch_notiz"] .")";
       echo "</small></small>";       
      }
     echo "<br>";
        if ($dsatz["nachname"] || $dsatz["vorname"] != "")
         {
          if ($dsatz["wikipedia"] != "")
          {
           echo "<a href=\"http://". $dsatz["wikipedia"] ."\" target=_blank><big>"
           . $dsatz["vorname"] ." ". $dsatz["nachname"] ."</big></a>";
          }
          else
          {
           echo "<big>";
           echo $dsatz["vorname"]," ",$dsatz["nachname"];
           echo "</big>";
          }
         }
        else
         {
          echo "<small><small>Autor nicht bekannt</small></small>";   } 
        echo "<br><br><br>";
 }




$res = mysql_query('SELECT FOUND_ROWS()') or die(mysql_error());
$total = mysql_result($res, 0, 0);

for($i=0; $i<ceil($total/$items_per_page); $i++) 
{
    echo $i;
    echo '<a href="?kategorie=Sonstiges&amp;page=$i">Seite x</a>';    
}  

?> 


<!-- -->

for($i=0; $i<ceil($total/$items_per_page); $i++) 
{
    $page_nr = $i+1;
    echo "<a href='?kategorie=$_GET[kategorie]&amp;page=$i'>$page_nr</a>";
    echo "&nbsp";
}

<style type="text/css">
  .hilight { color: red; }
</style>