return num_rows and query results

[eluser]TheFuzzy0ne[/eluser]
I know that if you're using MySQL, in which case you're query will be something like this:

Code:

$query = $this->db->query('SELECT SQL_CALC_FOUND_ROWS * FROM my_table');

But you'll still have to run a:

Code:

$query = $this->db->query('SELECT FOUND_ROWS()');

It's certainly more efficient than running the query twice. This might work on other database platforms, but I'm not sure.