Running a Query with in a foreach loop

[eluser]jshultz[/eluser]
I tried it with the way you had suggested but I was getting the same results. Here is what I have right now:

Site controller:

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();
            
            foreach( $data['projects']->result_array() as $project)
            {
                $project['tasks'] = $this->Project_model->getTasks( $project['ID'] );
            }
            
            $data['tasks'] = $this->Project_model->getTasks();

            $data['page_title'] = 'OSM Projects';
            $data['page'] = 'project-list-view'; // pass the actual view to use as a parameter
            $this->load->view('container',$data);
        
        }

    }