Hi there!
I'm pretty new to CakePHP and I recently met a problem that I actually can not resolve by myself, so I would like some help understanding the source of the problem. I have an events table that contains, with others things, a 'location_id' field. I have a locations table containing a 'country_id' field. And I have a countries table that contains some data related to specific countries. Now, what I would like to get, is a page containing data for a specific event: it works. But my array looks like this: Array ( [Event] => Array ( [id] => 1 [created] => 2010-09-22 23:57:39 [modified] => 2010-09-22 23:57:39 [name] => Test event [start_date] => 2010-09-23 20:00:00 [end_date] => 2010-09-24 03:00:00 [location_id] => 1 ) [Location] => Array ( [id] => 1 [name] => My home [street] => Here street [house_number] => 128 [zip_code] => 7000 [city] => Mons [country_id] => 1 ) ) I'd like to append a branch related to the country. I thought it could be "automagically" did, but I probably made a mistake. For now, in my events_controller file, I do this to get the data related to the location's country: $data['Country'] = ClassRegistry::init('Countries')->find( 'all', array( 'conditions' => 'Countries.id = '.$data['Location']['country_id'] ) ); $data['Country'] = $data['Country'][0]['Countries']; $this->set('data', $data); But It looks crap and I suppose that a "clean" way to to this exists. But I really do not know what to do with that. Please someone to help me? (-: Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en