Pagination and standard query

[eluser]nahalem[/eluser]
Hi,

Is it possible to build standard query like:

Code:

$this->db->query('....');

and implement pagination on it? If it's possible, how to do this?

[eluser]okiksetianto[/eluser]
kalau tidak salah itu berisi query SQL .

:cheese:

[eluser]InsiteFX[/eluser]
You need to pass it the limit and offset.

[eluser]nahalem[/eluser]
could you show me how to pass offset to te querry, LIMIT is easy...

[eluser]PhilTem[/eluser]
http://www.petefreitag.com/item/451.cfm