strankovanie

Mam spravene strankovanie. tu: http://www.ert.sk/1izb.php (mali by sa zobrazovat len 1 izbové byty) ked si ale kliknete dole na dalej alebo 2 stranka tak sa sice druha stranka zobrazi ale zobrazia sa vsetky byty nie len 1izb. vedel by mi s tym niekto pomoct?

predkladám zdroják:

<?php

@include_once('hlavicka.php');

require_once('spojit_s_dat.php'); 



unset($what);

unset($how);

unset ($name);





if ($_GET['serad_izieb']) {



    $what = "poc_izb";

    $name = "serad_izieb";

    $how = $_GET['serad_izieb'];



}



if ($_GET['serad_date']) {



    $what = "datum";

    $name = "serad_date";

    $how = $_GET['serad_date'];



}



if ($_GET['serad_obvod']) {



    $what = "obvod";

    $name = "serad_obvod";

    $how = $_GET['serad_obvod'];



}



if (!$what) $what = "id";

if (!$how) $how = "desc";



$vyber = "SELECT COUNT(*) as pocet FROM nehnutelnosti WHERE poc_izb='1 izbový byt' ";

$vysledok = @mysql_query($vyber); 

$pocet = mysql_result($vysledok, 0, "pocet");



 unset ($next);

unset ($prev); //



if ($_GET['od']) {

    $od = $_GET['od'];

     if ($od + 15 < $pocet) $next = $od + 15;

    if ($od - 15 >= 0) $prev = $od - 15;    //

} else {

    $od = 0;

     $next = 15; //

}



$stranek = ceil($pocet / 15);



$i = 0;



while ($i < $stranek) {

    if ($i * 15 == $od) {

        $menu .= " <span>".($i+1)."</span>";

    } else {

        $menu .= " <a href='ponuka.php?";

        if ($name) $menu .= "=".$how."&amp;";

        $menu .= "od=".($i*15);

        $menu .= "'>".($i + 1)."</a>";

    }

    $i++;

}



$vyber = "SELECT * FROM nehnutelnosti WHERE poc_izb LIKE '1 izbový byt' ORDER BY $what $how LIMIT $od, 15";



$vysledok = @mysql_query($vyber); 



if ($vysledok) { 

	

echo "<div id='celkove_ohr'><h2>aktuálna ponuka</h2>";

echo "<div style='border:2px;border-left:0px;border-right:0px;border-style:solid;  background-color:#E11E26;color:white;'>

<div style='float: left;margin-left:60px;'>

&nbsp;počet izieb: 

<a href='1izb.php' style='text-decoration:none;font-weight:normal;color:white;'>1</a>, 

<a href='2izb.php' style='text-decoration:none;font-weight:normal;color:white;'>2</a>, 

<a href='3izb.php' style='text-decoration:none;font-weight:normal;color:white;'>3</a>, 

<a href='4izb.php' style='text-decoration:none;font-weight:normal;color:white;'>4</a>, 

<a href='5izb.php' style='text-decoration:none;font-weight:normal;color:white;'>5 a viac</a>, 

<a href='gars.php' style='text-decoration:none;font-weight:normal;color:white;'>gars.</a>  ,

<a href='domy.php' style='text-decoration:none;font-weight:normal;color:white;'>domy</a>,   

<a href='pozemky.php' style='text-decoration:none;font-weight:normal;color:white;'>pozemky</  a>

<div style='float: right; width: 15%;'>

<a href='ponuka.php?serad_izieb=asc'><img src='images/triedh.gif' alt='' border='0' /></a>&nbsp;

<a href='ponuka.php?serad_izieb=desc'><img src='images/triedd.gif' alt='' border='0' /></a>&nbsp;izieb</div>

</div>

<div style='float: right; width: 11%;'>

<a href='ponuka.php?serad_date=asc'><img src='images/triedh.gif' alt='' border='0' /></a>&nbsp;

<a href='ponuka.php?serad_date=desc'><img src='images/triedd.gif' alt='' border='0' /></a>&nbsp;dátum</div>

<div style='float: right; width: 15%;'>

<a href='ponuka.php?serad_obvod=asc'><img src='images/triedh.gif' alt='' border='0' /></a>&nbsp;

<a href='ponuka.php?serad_obvod=desc'><img src='images/triedd.gif' alt='' border='0' /></a>&nbsp;obvod</div>

<div style='clear: both; height: 1px; font-size: 1px; line-height: 1px;'></div>

</div><p></p>";



// tuto to konci.



while ($riadok = mysql_fetch_array($vysledok)) { 

echo "<div id='ohr'><div style='float: left; width: 51%;background-color:#E6E6E6;'>&nbsp;&nbsp;

<b>".$riadok['kategoria']."</b>&nbsp;&nbsp;&nbsp;&nbsp;

".$riadok['poc_izb']."

</div><div style='float: right; width: 49%; text-align:right;background-color:#E6E6E6;'>";

if ($riadok['foto']==yes) {  // vloženie fotky

	echo "<a href='foto/{$riadok['id']}.html' target='_blank'><img src='images/foto.gif' alt='' border='0' /></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;";

}

echo "

".$riadok['obvod'].".&nbsp;&nbsp;&nbsp;

<b>".$riadok['cena']." SK</b>&nbsp;&nbsp;

</div></div><div style='clear: both; height: 1px; font-size: 1px; line-height: 1px;'></div>

<div id='ohr2' style='background-color:#E6E6E6';>

<div style='float: left; width: 68%; background-color:#E6E6E6;margin-left:10px;'>".$riadok['mesto'].",&nbsp  ;&nbsp;<b>".$riadok['ulica']."</b>, ".$riadok['text']."</div>

<div style='float: right; width: 30%; text-align:right; background-color:#E6E6E6;'>".$riadok['datum']."&nbsp;&nbsp;</div>

</div>

<div style='clear: both; height: 1px; font-size: 1px; line-height: 1px;'></div>

<div id='ohr'>&nbsp;</div>";



}



//

if (isset($prev)) {

    echo "<a href='ponuka.php?";

    if ($name) echo $name."=".$how."&amp;";

    echo "od=$prev";

    echo "'>Späť </a>";

}



if (isset($next)) {

    echo "<a href='ponuka.php?";

    if ($name) echo $name."=".$how."&amp;";

    echo "od=$next";

    echo "'> Ďalej</a>";

}

// 

echo $menu;

echo "<div id='dole'></div>";

echo '</div>';



mysql_free_result ($vysledok); 



} 



else { 



echo '<p>Zoznam inzerátov sa nedá zobraziť.'.mysql_error().'</p>'; 



}



mysql_close();

@include_once('paticka.php');

?>

<div id="">



</div>