SQL query with multiple Joins using CodeIgniter active records

Question

I have this working query:

$q = $this->db->query('SELECT u.name  FROM users u 
JOIN user_group ug ON u.id = ug.user_id 
JOIN groups g ON g.id = ug.group_id WHERE ug.group_id = "4" ');

And I want to replace it with aactive record. I come up with something like this but obviously it doesn't work :

$this->db->select('name');
   $this->db->from('users');
   $this->db->join('user_group', 'user_group.user_id = users.id);
   $this->db->join('groups', 'groups.id = user_group.group_id');
   $q = $this->db->get();

Thanks Leron

safarov · Accepted Answer · 2012-03-29 20:46:58Z

5

I think you forget add where clause. And there was single quote missing.

$this->db->select('name');
$this->db->from('users');
$this->db->join('user_group', 'user_group.user_id = users.id');
$this->db->join('groups', 'groups.id = user_group.group_id');
$this->db->where('user_group.group_id', 4);
$q = $this->db->get();

answered Mar 29, 2012 at 20:46

safarov

7,7942 gold badges38 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL query with multiple Joins using CodeIgniter active records

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related