Running a Query with in a foreach loop

[eluser]Phil Sturgeon[/eluser]
I just showed you! You want some help chewing your food too?!

Code:

function project_list()
    {
          if (!$this->tank_auth->is_logged_in()) {
            redirect('/auth/login/');
          } else {
            $this->load->model('Project_model');
            
            $data['projectList'] = $this->Project_model->selectFromProjects();
          
            $data['user_id']    = $this->tank_auth->get_user_id();
            $data['username']    = $this->tank_auth->get_username();

            $data['projects'] = $this->Project_model->getByUserId( $data['user_id'] );
            
            foreach( $data['projects']->result_array() as &$project)
            {
                $project['tasks'] = $this->Project_model->getTasksByProjectId( $project['ID'] );
            }
            
            $data['page_title'] = 'OSM Projects';
            $data['page'] = 'project-list-view'; // pass the actual view to use as a parameter
            $this->load->view('container',$data);
        
        }

    }

That will add a key 'tasks' into each project entry. I cannot make it any more obvious than that! :lol: