$start = 0;
   
    $sql = "SELECT
                sprueche.autor AS spruecheid,
                sprueche.kategorie,
                sprueche.spruch,
                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 '%" . $_POST["kategorie"]."%'
            ORDER BY
                sprueche.eingetragen_am DESC";
                
$res = mysql_query($sql);
$num = mysql_num_rows($res);
$sql = "SELECT
                sprueche.autor AS spruecheid,
                sprueche.kategorie,
                sprueche.spruch,
                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 '%" . $_POST["kategorie"]."%'
            ORDER BY
                sprueche.eingetragen_am DESC"
            LIMIT ".$_GET['start'].",20";
            
$res = mysql_query($sql);
for ($page=0;$page*20 < ($num-20);$page++)
{
    echo '<a href="test.php?start='.$page*20.'">'.($page+1).'</a>';
}              


while ($dsatz = mysql_fetch_assoc($res))
 {
     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 "<big><b>". $dsatz["spruch"] ."</b></big>";
     echo "<br>";
        if ($dsatz["vorname"] || $dsatz["nachname"] != "")
         {
          if ($dsatz["wikipedia"] != "")
          {
           echo "<a href=\"http://". $dsatz["wikipedia"] ."\" target=_blank><big>". $dsatz["vorname"] ." ". $dsatz["nachname"] ."</big></a>";
          }
          else
          {
           echo $dsatz["vorname"]," ",$dsatz["nachname"];
          }
         }
        else
         {
          echo "<small><small>Autor nicht bekannt</small></small>";
         } 
        echo "<br><br><br>";
     
 }

?>

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

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

$_POST["kategorie"] = '';

$items_per_page = 4;
$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.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)) ) 
{
  printf("%4d %s - %s (%s)<br />\n",
    ++$offset,
    htmlentities($dsatz['spruch']),
    htmlentities($dsatz['nutzername']),
    htmlentities($dsatz['wikipedia'])
  );
}

$res = mysql_query('SELECT FOUND_ROWS()') or die(mysql_error());
$total = mysql_result($res, 0, 0);
echo 'Seiten: ';
for($i=0; $i<ceil($total/$items_per_page); $i++) {
  echo $i+1," ";
}
?>