Running a Query with in a foreach loop

[eluser]verynewtothis[/eluser]
Try this in your first loop

Code:

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

This will pass the IDs to your getTaskByProjectID function.