Does your posts table have a field called period or is it period_id? If it's period, that's bad database design. You should change it to period_id so that it relates to the id column in the periods table. Then your problem is an easy one to overcome using table associations.
Jeremy Burns Class Outfit http://www.classoutfit.com On 22 Nov 2011, at 18:08, GG wrote: > I have two tables, a posts table, and a periods table. > > The posts table has a user_id, title, body, period. > > The periods table has a user_id, title, period. > > I can easily get the information from the posts table in my > PostsController.php: > > $this->set('period1', $this->Post->find('all', array( > > 'conditions'=>array('user_id'=>$this->Session- >> read('Auth.User.id'), 'class_period'=>1) > ))); > > But I cannot get the information from the periods table. I think this > would be the equivalent of a Left Join? > > I would like to echo all periods with a user_id that matches the > (Auth.User.id). > > Thanks! > > -- > Our newest site for the community: CakePHP Video Tutorials > http://tv.cakephp.org > Check out the new CakePHP Questions site http://ask.cakephp.org and help > others with their CakePHP related questions. > > > To unsubscribe from this group, send email to > [email protected] For more options, visit this group at > http://groups.google.com/group/cake-php -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
