• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
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

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.