Is it possible with Active Record?

Hello!

I have this embedded db query, and I want to rewrite it in Active Record-style:

PHP Code:

 $sql = "SELECT id, fullname, phone FROM users WHERE country=(SELECT country_id FROM country WHERE name=?) AND  type=?"; 


Is it possible? If so, can you please tell me how can I start with it?

Thank you!

$this->db->select('user.id,user.fullname,user.phone');
$this->db->from('user');
$this->db->join('country', 'country.country_id = user.country_id');
$this->db->where('country.name' , $name);
$this->db->where('user.type' , $type);
$query = $this->db->get();
Can you list all column/field of user & country table. My assumption is find user based on their country & user role.

Keep calm.

PHP Code:

 $sql = "SELECT id, fullname, phone FROM users WHERE country=(SELECT country_id FROM country WHERE name=?) AND  type=?"; 


Simple with query bindings (without AR or QB):

PHP Code:

$sql = "SELECT id, fullname, phone FROM users WHERE country=(SELECT country_id FROM country WHERE name=?) AND  type=?";
$this->db->query($sql, array($name, $type)); 


Query Bindings

Thank you @arma7x, you helped a lot with understanding of joins! Now I can rewrite it with active record.

You're welcome, did you still using v2.x.x. Please upgrade to ver 3.0.5.

Keep calm.

You're welcome, did you still using v2.x.x. Please upgrade to ver 3.0.5.

What made you think that I'm using 2.x.x? :O I'm using 3.0.5 (from now on, 3.0.6).

Due to
3.0 .0's renaming of Active Record to Query Builder

Keep calm.