Welcome Guest, Not a member yet? Register   Sign In
Is it possible with Active Record?
#2

(This post was last modified: 03-19-2016, 02:22 PM by arma7x. Edit Reason: typo )

$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.
Reply


Messages In This Thread
Is it possible with Active Record? - by fulopm - 03-19-2016, 11:39 AM
RE: Is it possible with Active Record? - by arma7x - 03-19-2016, 02:06 PM



Theme © iAndrew 2016 - Forum software by © MyBB