Should you name your table competence_ratings? 2012/8/4 orbb <[email protected]>: > Im new to cakePHP and the whole table relations concept is very confusing! > > I have 2 tables, competencies and competenceRatings. competencies stores a > list of names with ids. > > competencies > ------------ > id > name > > And users can select various competencies from this table and rate them and > their ratings are stored into competenceRatings table. > > competenceRatings > ----------------- > id > competence_id > user_id > rating > > I want to be able to get the names of competencies for which a user have NOT > made any ratings into competenceRatings table. i.e., I need list of names > from competencies table for which there are no entries in comptenceRatings > table(for given user_id). > > I tried competencies->hasMany->competenceRatings, > competenceRatings->belongsTo->competencies relations. > > > $competencies = > $this->Competence->CompetenceRating->find('all',array('CompetenceRating.user_id' > => $userId,'CompetenceRating.competence_id !=' => 'Competence.id')); > > But no use! > > Does this result require any other relations? Or can i just join tables > using joins condition in find query? > > 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
-- Pozdrawiam Dominik Gajewski -- 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
