Running a Query with in a foreach loop

[eluser]Phil Sturgeon[/eluser]
http://www.phpbuilder.com/manual/en/lang...s.pass.php

If you pass by reference instead of making a copy you are modifying the original variable.

So:

Code:

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

is effectively the same as:

Code:

$projects = array();
foreach( $data['projects'] as $project)
{
    $project['tasks'] = $this->Project_model->getTasks( $project['ID'] );
    $projects[] = $project;
}

$data['projects'] = $projects;
unset($projects);

See what im getting at?

Instead of creating a new array to hold them all then assigning it to the same value and unsetting the temporary array, you just modify the original variable on the fly.

Basically stop returning $query and return $query->result_array() and use the code with the & in, it will work. :-)