• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Multiple table relationanal query

#1
[eluser]Unknown[/eluser]
Hello,
I'm very new to CI. I've been looking around for a multiple associated table example online and I cant find one. So my question is if I have two tables like so:
Code:
---------                    ------------
| USERS |                    | COMMENTS |
| ----- |                    | -------- |
| Id    |-------------------<| Users_Id |
| Name  |                    | Text     |
| Last  |                    ------------
---------
and we have a one to many relationship, where a user can have multiple comments.
whats the statement I have to use to get all the comments of a user given a name?

I'm a CakePHP guy, and I like the loosens of CI that's why I'm exploring CI and I like it so far.

#2
[eluser]Future Webs[/eluser]
check the user guide for the database class and the join function

Code:
$this->db->join


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


Users browsing this thread:
1 Guest(s)


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2019 MyBB Group.