+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived General Discussion (https://forum.codeigniter.com/forumdisplay.php?fid=21)
+--- Thread: Pagination problem! (/showthread.php?tid=26589)
Pagination problem! - El Forum - 01-18-2010
[eluser]Unknown[/eluser]
hello everyone, I,m using codeigniter for several days now, and its all fine, but i'm having little problems with my pagination.
in my database I have table named content where the all main content for my web is stored, with columns: id, section_id, title, conntent.
How can I fetch all rows in table where for example section_id = 2 and set pagination to work properly
I used to work this way with query url; www.example.com?index.php?section_id=$id&page;=$page
i hope you understand what i mean and sorry for my english.
thanks
Pagination problem! - El Forum - 01-18-2010
[eluser]flaky[/eluser]
Code:
$this->db->where('section_id', $section_id);
$this->db->limit($limit, $offset);
$this->db->get('content');Pagination problem! - El Forum - 01-18-2010
[eluser]Unknown[/eluser]
hey thanks a lot, that was really simple
..., just need some pratice with codeigniter!