Unexpected results in print_r

[eluser]jshultz[/eluser]
I have a join I'm doing between two tables but i'm getting unexpected results from the query. I know it's returning something, though.

here's my model:

Code:

function tasksByProjectId() {
    /* $sql = "SELECT `projectid` \n"
    . "FROM `projects` \n"
    . "LEFT JOIN `tasks` ON tasks.project_id = projects.projectid LIMIT 0, 30 ";
     */
    
    $this->db->select('projectid');
    $this->db->from('projects');
    $this->db->join('tasks', 'tasks.project_id = projects.projectid', 'full');
    return $this->db->get();
}

and then in the controller it's just a simple:

Code:

$data['tasksByProject'] = $this->Project_model->tasksByProjectId();

and in the view I put a:

Code:

<pre>
&lt;?php
    foreach($tasksByProject as $row)
    {print_r($row);
    }
    
?&gt;
</pre>

just so i could see what was coming out. Now, here's the odd thing. Depending on whether or not I do a left or full join I'll get various amounts of empty rows from this code:

Code:

<table>
        <tr><th>Project ID</th><th>Project Name</th><th>Task ID</th><th>Task Name</th></tr>
&lt;?php foreach($projectPlusTasks->result() as $row): ?&gt;
    
    <tr>
        <td>&lt;?=$row->projectid?&gt;</td>
        <td></td>
        <td></td>
        <td></td>
    </tr>
    
&lt;?php endforeach; ?&gt;
</table>

What's going on?

Here's what I get from the print_r:

Code:

Resource id #29Resource id #44Array
(
)
Array
(
)
03