Welcome Guest, Not a member yet? Register   Sign In
My join is not working
#6

You haven't select your office.names, try this :

PHP Code:
$this->db->select('phones.users, phones.numbers');
           
$this->db->select('offices.names');
           
$this->db->from('phones');
           
$this->db->join('offices''phones.offices = offices.id''left');
           
$this->db->like('phones.users',$param);
           
$this->db->or_like('phones.numbers'$param);
           
$this->db->or_like('offices.names'$param); 

Reply


Messages In This Thread
My join is not working - by andyblem - 02-19-2015, 06:00 AM
RE: My join is not working - by Avenirer - 02-19-2015, 06:46 AM
RE: My join is not working - by marcos - 02-19-2015, 07:49 AM
RE: My join is not working - by edellascenza - 02-19-2015, 10:54 AM
RE: My join is not working - by andyblem - 02-19-2015, 11:43 PM
RE: My join is not working - by Rufnex - 02-20-2015, 02:47 AM



Theme © iAndrew 2016 - Forum software by © MyBB