Running a Query with in a foreach loop

[eluser]jshultz[/eluser]
Then what would be the right way to do it?

Here's what I have in the site controller currently:

Code:

function project_list()
    {
          if (!$this->tank_auth->is_logged_in()) {
            redirect('/auth/login/');
          } else {
            $this->load->model('Project_model');
            /*$data['query'] = $this->Project_model->getAll();*/
            $data['projectList'] = $this->Project_model->selectFromProjects();
            $data['projects'] = $this->Project_model->getByUserId();
            $data['tasks'] = $this->Project_model->getTasksByProjectId();
            $data['user_id']    = $this->tank_auth->get_user_id();
            $data['username']    = $this->tank_auth->get_username();
            $data['page_title'] = 'OSM Projects';
            $data['page'] = 'project-list-view'; // pass the actual view to use as a parameter
            $this->load->view('container',$data);
        
        }

    }