Solved : Newbie question - Working with models

[eluser]m4rw3r[/eluser]
I cannot see why it would be forbidden.

Here is an example of using data from the first query in the second:

Code:

// first query, fetch a page:
$q = $this->db->get_where('pages', array('title' => 'About'), 1);
$page = $q->row();

// get all comments
$q = $this->db->get_where('comments', array('page_id' => $page->id));
$page->comments = $q->result();                     //   ^^^^^^^^^ That fetches the data from the page we previously loaded

return $page;