Displaying a table of results

[eluser]mdcode[/eluser]
Thanks for the answers guys, I have been trying joins to no avail and if I use this code:

Code:

function get_last_ten_entries()
{
$this->db->select('projects.id, projects.customer, projects.date_required, projects.job_status, customers.id, customers.name');
$this->db->from('projects, customers');
$this->db->join('customers', 'projects.customer = customers.id', 'inner');
$this->db->order_by('projects.id', 'DESC');
$this->db->limit(10);
        
$query = $this->db->get();
}

I get the error:

Code:

A PHP Error was encountered
Severity: Warning
Message: Invalid argument supplied for foreach()
Filename: pages/projects_reports.php
Line Number: 35

The foreach code on my view is like this (which could be wrong, though work when only the customer.id is used):

Code:

foreach($query as $row){
echo "<tr>";
echo "<td>". $row->id ."</td>";
echo "<td>". $row->name ."</td>";
echo "<td>". $row->date_required ."</td>";
echo "<td>". $row->job_status ."</td>";
echo "</tr>";
}