[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.