Running a Query with in a foreach loop

[eluser]Phil Sturgeon[/eluser]
Not really what he meant.

Dude, I would do this in your controller.

Code:

$data['projects'] = $this->projects_model->getByUserId( $user_id )->results();

foreach($data['projects'] as &$project)
{
    $project['tasks'] = $this->tasks_model->getTasksByProjectId( $project->ID )->results();
}

That will add 'tasks' key into each project item (by reference, that is what the & is doing) and mean you can add a foreach within your main foreach.

Although I wouldn't make a habit of returning the $query object, you should pick a type of result or row to return and just send that back as an array or object.