Searching multiple tables - fields

Try this:

controller:

PHP Code:

$this->load->helper('array');
$this->load->model('company_model');
$data['city'] = 'New York';  //example of city in your search box
$data['category'] = 15;    //example of category_id in your search box
$s_result = $this->company_model->search_result($data);
echo '<pre>';
print_r($s_result);
echo '</pre>'; 


company_model:

PHP Code:

public function search_result($data)
{
  $s_category = element('category',$data,NULL);  //element is array helper function!
  $s_city = element('city',$data,NULL);
  $s_name = element('name',$data,NULL);

  $this->db
  ->select('cot.*,cit.*,cat.*')
  ->from('company_table cot')
  ->join('company_information_table cit','cot.company_id = cit.company_id')
  ->join('category_table cat','cot.category_id=cat.category_id');
  if ($s_category) $this->db->where('cot.category_id',$s_category);
  if ($s_city) $this->db->where('cit.company_city',$s_city);
  if ($s_name) $this->db->where('cot.company_name',$s_name);
  $this->db->order_by('cot.company_id','ASC');
  $query = $this->db->get();
  if ($query->num_rows() == 0) {
    return FALSE;
  }
  else {
    return $query->result();
  }
}