Welcome Guest, Not a member yet? Register   Sign In
Codeigniter Join query
#4

Try this:

PHP Code:
$this->db
->select('u.user_id,u.user_name,u.user_role,u.status,b.building_admin_id')
->
from('users u')
->
join('building_admins_tbl b','u.id = b.building_admin_id')
->
where('u.user_role >=' '1')
->
where('u.status =>''1')
->
where('b.building_admin_id',NULL);
$q $this->db->get();
$admin_list =$q->result_array(); 
Reply


Messages In This Thread
Codeigniter Join query - by akgarg007 - 12-10-2017, 07:52 AM
RE: Codeigniter Join query - by Kaosweaver - 12-11-2017, 06:52 AM
RE: Codeigniter Join query - by dave friend - 12-11-2017, 09:21 AM
RE: Codeigniter Join query - by Wouter60 - 12-11-2017, 09:45 AM



Theme © iAndrew 2016 - Forum software by © MyBB