Pagination errors...a lot - Printable Version +- CodeIgniter Forums (https://forum.codeigniter.com) +-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20) +--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23) +--- Thread: Pagination errors...a lot (/showthread.php?tid=3893) |
Pagination errors...a lot - El Forum - 10-27-2007 [eluser]feri_soft[/eluser] Today i hoped i can get my app running and this pagination class killed me .... Here is the part of the controller: Code: $cat_info = $this->products->getCatInfo($this->uri->segment(2)); // Cat info based on the cat url_name value The model: Code: function getCurProducts($catID, $limit, $offset){ Code: <?php if($subcats != 0):foreach ($subcats as $subcat):?> And now i get: <div id="product_5" class="product_container"> <div id="img"></div>sdf on the first and <div id="product_" class="product_container"> <div id="img"></div>sdf on the second page With different code like left joins and changing the query syntax a bit i came up with results like same ids on all pages or first page working second page with no results and so on. Please give me the correct query for what i am trying to do. On pagination i want not only to show the products but images and cats names so i need to join them. Without the join stuff the query is perfect and all is fine. When i attempt join in combination with pagination all screws up. PLease help! Pagination errors...a lot - El Forum - 10-28-2007 [eluser]feri_soft[/eluser] NO one have ideas? It seems like a common thing with join and pagination as there were other posts on this one but i couldnt find the solution? |