Pagination over resultset

Pagination over resultset

El Forum
Guest

01-13-2010, 03:18 PM

[eluser]Colin Williams[/eluser]
You just need to limit your query with SQL

Code:
$this->db->query('SELECT * FROM my_table LIMIT ?, ?', array($offset, $limit));

// Where $limit = per_page setting and $offset is the current offset as passed in the URI

Messages In This Thread

Pagination over resultset - by El Forum - 11-17-2009, 12:55 PM

Pagination over resultset - by El Forum - 11-17-2009, 02:14 PM

Pagination over resultset - by El Forum - 01-13-2010, 03:10 PM

Pagination over resultset - by El Forum - 01-13-2010, 03:18 PM

Pagination over resultset - by El Forum - 01-13-2010, 03:33 PM

Pagination over resultset - by El Forum - 01-13-2010, 03:39 PM

Pagination over resultset - by El Forum - 01-15-2010, 03:10 PM

Pagination over resultset - by El Forum - 01-15-2010, 03:17 PM