nepadejo...:/
"exoticdevil" <born4devil@gmail.com> wrote in message 
news:hpi4bm$abs$1@trimpas.omnitel.net...
> nemanau, kad tai pades, nes tada antram puslapi nebus rezultatu 
> vistiek..pameginsiu...
> "323" <323@nomail.lt> wrote in message 
> news:hph6fr$rkk$1@trimpas.omnitel.net...
>> $offset = ($pageNum - 1) * $rowsPerPage;
>> $query = " SELECT * FROM items WHERE itemsubcat = '$cat' LIMIT $offset,
>>
>> sakyciau tas LIMIT tau ir grazina tik tiek, kiek $ofsetas yra ....
>> nuimk LIMIT
>>
>> "exoticdevil" <born4devil@gmail.com> wrote in message 
>> news:hph1km$mso$1@trimpas.omnitel.net...
>>> nu rezultatus normalius gaunu, bet antro page neatidaro, kai nuimu WHERE 
>>> itemsubcat = '$cat'" nuo abieju querry visus rezultatus gerai 
>>> ispauzdina, tai klaida padariau sitam dalyke, bet kokia? negi reik is 
>>> esmes pasikeisti scripta, querry detis i masyva, o po to ji isskirstyti 
>>> i puslapius. Googlej maciau keleta tokiu...
>>> "gopas" <netikras@jamailas.lt> wrote in message 
>>> news:hph15n$mm1$1@trimpas.omnitel.net...
>>>> tai echo $query, ir ziurek kas blogai.
>>>>
>>>> "exoticdevil" <born4devil@gmail.com> wrote in message 
>>>> news:hpg6ft$be7$1@trimpas.omnitel.net...
>>>>> Turiu pasidares scriptuka paging, viskas ok veikia,naudoju kituose 
>>>>> vietose
>>>>> puslapyje,  bet dabar is db lenteles prireike paimti ne visus 
>>>>> duomenis, o
>>>>> tik kai kuriuos, ir kazko neveikia,tiksliau pusiau veikia, pirma 
>>>>> puslapi
>>>>> sugeneruoja, o paspaudus ant sekancio nieko nerodo, tarsi isvis 
>>>>> paging'o
>>>>> nebutu... nesuprantu kur klaida iveliau, su queriu kazkas ne taip
>>>>> manau...visa vakara prasedejau, nebelaiko nervai jau, gal kas 
>>>>> padesit..
>>>>> (sorry del netvarkos)
>>>>>
>>>>> <?php
>>>>>
>>>>> $cat = $_GET['cat'];
>>>>>
>>>>>
>>>>> include ('admin/sqlcon.php');
>>>>>
>>>>> mysql_select_db("shop");
>>>>>
>>>>> $rowsPerPage = 5;
>>>>> $pageNum = 1;
>>>>>
>>>>> if(isset($_GET['page']))
>>>>> {
>>>>>    $pageNum = $_GET['page'];
>>>>> }
>>>>>
>>>>> $offset = ($pageNum - 1) * $rowsPerPage;
>>>>> $query = " SELECT * FROM items WHERE itemsubcat = '$cat' LIMIT 
>>>>> $offset,
>>>>> $rowsPerPage";
>>>>> $result = mysql_query($query) or die('Error, query failed');
>>>>>
>>>>> while($row = mysql_fetch_array($result))
>>>>> {
>>>>>
>>>>>    echo $row["itemcode"]. "<br>";
>>>>>
>>>>>
>>>>> }
>>>>>
>>>>> $query   = "SELECT COUNT(itemsubcat) AS numrows FROM items WHERE 
>>>>> itemsubcat
>>>>> = '$cat'";
>>>>> $result  = mysql_query($query) or die('Error, query failed2');
>>>>> $row     = mysql_fetch_array($result, MYSQL_ASSOC);
>>>>> $numrows = $row['numrows'];
>>>>> $maxPage = ceil($numrows/$rowsPerPage);
>>>>> $self = $_SERVER['PHP_SELF'];
>>>>> $nav  = '';
>>>>>
>>>>> for($page = 1; $page <= $maxPage; $page++)
>>>>> {
>>>>>   if ($page == $pageNum)
>>>>>   {
>>>>>       $nav .= "[$page]";
>>>>>   }
>>>>>   else
>>>>>   {
>>>>>       $nav .= " <a href=\"$self?page=$page\">$page</a> ";
>>>>>   }
>>>>> }
>>>>>
>>>>> if ($pageNum > 1)
>>>>> {
>>>>>    $page  = $pageNum - 1;
>>>>> }
>>>>>
>>>>> if ($pageNum < $maxPage)
>>>>> {
>>>>>    $page = $pageNum + 1;
>>>>> }
>>>>> echo $nav ;
>>>>>
>>>>> ?>
>>>>>
>>>
>>
>>
>