Joins and error handling

[eluser]davidbehler[/eluser]
Just change

Code:

$this->db->join('master_charges', 'master_property_details.property_id = master_charges.property_id');
$this->db->join('master_contactdetails', 'master_property_details.property_id = master_contactdetails.property_id');

to

Code:

$this->db->join('master_charges', 'master_property_details.property_id = master_charges.property_id', 'left outer');
$this->db->join('master_contactdetails', 'master_property_details.property_id = master_contactdetails.property_id', 'left outer');

That way your join will be an outer join and return results even though master_charges or master_contactdetails is empty.