strankovanie

<?php
$result = mysql_query("SELECT count(*) FROM novinky ORDER BY id DESC", $db); 
if($result !== false) { 
   list($numRows) = mysql_fetch_row($result); 
}
$spolu = $numRows;
$pages = 10;
$zobraznav = 5;
$stranok = ceil($spolu / $pages);

if(!isset($_GET['offset'])) {
$offset = 0;
} else {
$offset = addslashes($_GET['offset']);
}

$prva = $offset;
$druha = $offset + $pages;

$zac = "|&lt;";
$kon = "&gt;|";
$spa = "Späť";
$dal = "Ďalej";

$finish = $stranok * $pages - $pages;

$sp = $offset - $pages;
$da = $offset + $pages;

$result = mysql_query($q="SELECT nazov,text FROM novinky LIMIT $prva,$druha", $db ) or print("Došlo k chybě v dotazu: ".$q."<br>".mysql_error());
  while ($zaznam=MySQL_Fetch_Array($result)){
    echo $zaznam['nazov'];
    echo $zaznam['text'];
  }
  
$zaciatok = "<a href=\"mojestrankovanie.php?offset=0\">" . $zac . "</a>";
$koniec = "<a href=\"mojestrankovanie.php?offset=$finish\">" . $kon . "</a>";
$spat = "<a href=\"mojestrankovanie.php?offset=$sp\">" . $spa . "</a>";
$dalej = "<a href=\"mojestrankovanie.php?offset=$da\">" . $dal . "</a>";

$aktual = $offset + $pages / $pages;
$info = $zobraznav - 1;
$plus = $info / 2;
$plus2 = $info / 2;
$akt = $offset;
$akt2 = $offset;

echo $zaciatok;
echo $spat;
while ( $plus !== 0 && $plus > 0 ) {
$akt = $akt - $pages;
$aktu = $akt / $pages + 1;
echo "<a href=\"mojestrankovanie.php?offset=$akt\">" . $aktu . "</a>|";
}
while ( $plus2 !== 0 && $plus2 > 0 ) {
$akt2 = $akt2 - $pages;
$aktu2 = $akt2 / $pages + 1;
echo "<a href=\"mojestrankovanie.php?offset=$akt2\">" . $aktu2 . "|</a>";
}
echo $dalej;
echo $koniec;
?>