Welcome Guest, Not a member yet? Register   Sign In
Joining two seperate tables


No worries, Glad to be of help


Nice post... can u share your expierence ?

$this->db->join('members', 'member_profile.user_id = usr.id');

will basically join "members" with "member_profile" where `id` = `$id` which will pull information on that member from the user tables and the profile tables corresponding to that member's id.

active record class Smile more info here Active record in user manual.

Hope this helps other users.

Theme © iAndrew 2016 - Forum software by © MyBB