CodeIgniter Forums

Full Version: Multiple table relationanal query
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

El Forum

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

El Forum

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

Code:
$this->db->join