return num_rows and query results

[eluser]TheFuzzy0ne[/eluser]
No, it's not possible to do this natively with the AR class, as SQL_CALC_FOUND_ROWS is not supported by all database platforms natively.

The same thing using the Active Record class might go something like this:

Code:

$this->db->select('SQL_CALC_FOUND_ROWS *', FALSE);
$res = $this->db->get('my_table');
$res_count = $this->db->query('SELECT FOUND_ROWS()');