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

[eluser]JayArias[/eluser]
fixed.
#2

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


Obiron
#3

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

[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.
#5

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

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




Theme © iAndrew 2016 - Forum software by © MyBB