Joining two seperate tables

[eluser]JayArias[/eluser]
fixed.

[eluser]obiron2[/eluser]
No worries, Glad to be of help


Obiron

[eluser]mk3[/eluser]
Nice post... can u share your expierence ?

[eluser]JayArias[/eluser]
sure,

Code:

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

[eluser]mk3[/eluser]
active record class more info here Active record in user manual.

[eluser]JayArias[/eluser]
Hope this helps other users.