return num_rows and query results

[eluser]Samuurai[/eluser]
[quote author="TheFuzzy0ne" date="1243635521"]

Code:

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

[/quote]

Wow - advanced stuff! I was more hoping to sort it out at the PHP level..

For instance, just using regular PHP, you can do this:

Code:

$result = mysql_query("SELECT * FROM table1", $link);
$num_rows = mysql_num_rows($result);
// Do foreach() with $result

Is this possible with the active record functions? - I'm still trying to figure out how to transport the data around the MVC architecture .