Welcome Guest, Not a member yet? Register   Sign In
Running a Query with in a foreach loop
#14

[eluser]jshultz[/eluser]
Ok, here's an update on what I've been doing. I decided to rework my code just a bit and I have this block now:

Code:
<div><table>
        <tr><th>Project</th><th>Due Date</th><th>Date Added</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 foreach($tasks->result() as $row) : ?&gt;
        
            &lt;?php
                if ($tasks->projectid === $projects->id) {
                    echo "<tr><td><p><strong>" . $row->task . "</strong></p></td><td>" . $row->due_date . "</td></tr>";
                }
                else {
                    echo "<tr><td><p><strong>There is no task</strong></p></td><td><p><strong>No Due Date</strong></p></td></tr>";
                }
                ?&gt;
                
        &lt;?php endforeach; ?&gt;
        
    
    &lt;?php endforeach; ?&gt;
    </table></div>

My problem is that it's echoing at every task (there's 3 each with a different projectid). My concern is that if I change
Code:
($tasks->projectid === $projects->id)
to ($tasks->projectid != $projects->id) then I get the else response. Why is that? I checked the id of the projects and they are 26 through 30 and the projectids of the tasks are 26, 28 and 30. Obviously, at least to me, they are not all equal to each other. What am I missing?


Messages In This Thread
Running a Query with in a foreach loop - by El Forum - 08-09-2009, 10:56 PM
Running a Query with in a foreach loop - by El Forum - 08-10-2009, 12:04 AM
Running a Query with in a foreach loop - by El Forum - 08-10-2009, 02:07 AM
Running a Query with in a foreach loop - by El Forum - 08-10-2009, 07:52 AM
Running a Query with in a foreach loop - by El Forum - 08-10-2009, 08:34 AM
Running a Query with in a foreach loop - by El Forum - 08-10-2009, 08:56 AM
Running a Query with in a foreach loop - by El Forum - 08-10-2009, 09:41 AM
Running a Query with in a foreach loop - by El Forum - 08-10-2009, 10:27 AM
Running a Query with in a foreach loop - by El Forum - 08-10-2009, 11:12 AM
Running a Query with in a foreach loop - by El Forum - 08-10-2009, 11:39 AM
Running a Query with in a foreach loop - by El Forum - 08-10-2009, 04:13 PM
Running a Query with in a foreach loop - by El Forum - 08-10-2009, 05:20 PM
Running a Query with in a foreach loop - by El Forum - 08-10-2009, 08:22 PM
Running a Query with in a foreach loop - by El Forum - 08-11-2009, 04:15 PM
Running a Query with in a foreach loop - by El Forum - 08-12-2009, 02:38 AM
Running a Query with in a foreach loop - by El Forum - 08-12-2009, 03:40 AM
Running a Query with in a foreach loop - by El Forum - 08-12-2009, 08:38 AM
Running a Query with in a foreach loop - by El Forum - 08-13-2009, 09:05 AM
Running a Query with in a foreach loop - by El Forum - 08-13-2009, 09:18 AM
Running a Query with in a foreach loop - by El Forum - 08-13-2009, 09:33 AM
Running a Query with in a foreach loop - by El Forum - 08-15-2009, 10:34 PM



Theme © iAndrew 2016 - Forum software by © MyBB