CodeIgniter Forums
Pagination with mysql - Printable Version

+- 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 with mysql (/showthread.php?tid=12148)



Pagination with mysql - El Forum - 10-08-2008

[eluser]frietkot[/eluser]
Hi,

I was wondering, what is the relation with the pagination class to a database query and how can I use the pagination class with database results.


Pagination with mysql - El Forum - 10-08-2008

[eluser]xwero[/eluser]
For the total_rows Pagination setting you need to get the total amount of rows from the db and the per_page setting is the limit of rows you are going to display.


Pagination with mysql - El Forum - 10-08-2008

[eluser]frietkot[/eluser]
But there's no direct relation between the pagination class and the database class?


Pagination with mysql - El Forum - 10-08-2008

[eluser]xwero[/eluser]
no