Running a Query with in a foreach loop

[eluser]jshultz[/eluser]
I feel like I'm on the right track with this but I'm missing something.

I have a query that runs through a list of projects by the user id:

Code:

function getByUserId() {
    $user_id = $this->tank_auth->get_user_id();
    return $this->db->get_where('projects', array('user_id'=>$user_id));
}

On the view page I have a foreach loop that cycles through the code:

Code:

<table>
        <tr><th>Project</th><th>Due Date</th></tr>
    &lt;?php foreach($projects->result() as $row): ?&gt;
    
        <tr>
            <td><p>&lt;?=$row->project_name?&gt;</p></td>
            <td><p>&lt;?=$row->due_date?&gt;</p></td>
            <td></td>
        </tr>
    
    &lt;?php endforeach; ?&gt;
    </table>

Now, I'm wanting to insert before the end the following code:

Code:

<?php foreach($tasks->result() as $row): ?>
        <tr>
            <td><p>&lt;?=$row->tasks?&gt;</p></td>
            <td><p>&lt;?=$row->due_date?&gt;</p></td>
            <td></td>
        </tr>
    &lt;?php endforeach; ?&gt;

As you might imagine, it's going to get a list of tasks associated with the project that it just cycled through. I'm sure it's simple, I just want to pass a variable to this function:

Code:

function getTasksByProjectId($ID) {
    return $this->db->get_where('tasks', array('projectid'=>$projectID));
}

My idea is that when it goes through the loop it has the ID of the project in the array and somehow magical elves will get that id to the function and tell it what tasks it should be spitting out. Unfortunately for me, I haven't found the elves that are going to be relaying that information.

Any suggestions?