DMZ 1.7.1 (DataMapper OverZealous Edition)

[eluser]ramm[/eluser]
Oh, i'm sorry i didn't know it was only for 1.7.1, thought it was growing together...

Anyway, this is the way i do it without ORM, using only CI libraries:

Code:

function test()
    {
        $this->load->model(array('chains_model', 'restaurants_model'));
        $chains = $this->chains_model->get_chains();
        foreach($chains as $c)
        {
            echo "<h3>".$c->name.</h3>;
            $restaurants = $this->restaurants_model->get_restaurants(array('chain' => $c->id));
            foreach($restaurants as $r)
            {
                echo $r->name."<br />";
            }
        }
    }

I need something like this:

Chain: McDonalds
-Mc Donalds Rest I35 North
-Mc Donalds Austin HWY
-Mc Donalds O'Connor Road

Chain: Subway
-Subway Forum
-Subway Nacogdoches
-Subway Northstar Mall

Chain: Red Lobster
-Red Lobster I35 North

And so on...