How to write models

[eluser]papagno[/eluser]
I'll use an example. We have two entities: posts and comments (each post can have many comments). This could be a basic posts model:

Code:

class Post extends CI_Model
{
    function __construct()
    {
        parent::__construct();
    }
    
    function get_posts()
    {
        $query = $this->db->get('posts');
        return $query->result();
    }

Now in the posts controller I can use:

Code:

$this->load->model('post');
$posts = $this->post->get_posts();

But $posts is not an array of objects, it's just a multidimensional array. So I don't know how (and where) to add a method to fetch comments for a post.

p.s. I'm sorry for my English