Is it possible with Active Record? |
03-19-2016, 02:06 PM
(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.
|
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
RE: Is it possible with Active Record? - by ardhie1032 - 03-19-2016, 03:29 PM
RE: Is it possible with Active Record? - by fulopm - 03-19-2016, 03:39 PM
RE: Is it possible with Active Record? - by arma7x - 03-20-2016, 03:16 PM
RE: Is it possible with Active Record? - by fulopm - 03-21-2016, 12:06 PM
RE: Is it possible with Active Record? - by arma7x - 03-21-2016, 12:34 PM
|