Why are you using a hasMany instead of a hasAndBelongsToMany? You wouldn't need the id column as you two ideas together would be your index.
- "The cold winds are rising" On Sep 16, 2012 5:17 PM, "Nvp" <[email protected]> wrote: > Hi! > I built DB with tables: > > *restaurants* - main table > > *kitchens* - second table > > *kitchen_restaurants* - join table with fields: id, kitchen_id, > restaurant_id > > *Model/Restaurant.php*: > public $hasMany = array( > 'KitchenRestaurant' > ); > > *Model/Kitchen.php*: > public $hasMany = array( > 'KitchenRestaurant' > ); > > *Model/KitchenRestaurant.php*: > public $belongsTo = array( > 'Restaurant', 'Kitchen' > ); > > The problem is that I have separate controller for my main page in which I > need to retrieve data from this models with complex conditions. > > I added > > public $uses = array('Restaurant'); > > to my main page controller and here comes the part where I need your > advices. > > I need to select only those restaurants where kitchen = $id. I've tried to > add > public function index() { > $this->set('rests', $this->Restaurant->find('all', array( 'conditions' => > array('Restaurant.active' => "1", 'KitchenRestaurant.id' => "1") ))); } > > but I get Column not found error. How to properly retrieve data in hasMany > through or HABTM? > Thanks! > > -- > Like Us on FacekBook https://www.facebook.com/CakePHP > Find us on Twitter http://twitter.com/CakePHP > > --- > You received this message because you are subscribed to the Google Groups > "CakePHP" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > Visit this group at http://groups.google.com/group/cake-php?hl=en. > > > -- Like Us on FacekBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. Visit this group at http://groups.google.com/group/cake-php?hl=en.
