count database records + limit

[eluser]naren_nag[/eluser]
If you using CI's active record pattern, then you can use this to get the total number of results for a query you are building.

Code:

$this->db->count_all_results();

Or you can use this to get the total number of rows in a table

Code:

$this->db->count_all();

Please take a look at CI's documentation for the database class.

cheers,

naren