Thanks, i didn't know I had a reference to the City row to which belongs the house! Thank you very much!
On 27 Ott, 10:14, DanielMedia <[EMAIL PROTECTED]> wrote: > J. Eckert was right. If you setup your associations that way, you > should only get 1 city, 1 region and 1 state for each house. > > Here's a zip file with a complete example of how to pull it off: > > http://www.experiment621.com/stuff/test_geography.zip > > The zip file includes: > ---------------------------------------------- > - SQL file to create test database called "test_geography" with some > sample data. > - Models, View, Controller > > Model Associations > ---------------------------------------------- > House > belongsTo > City > City > belongsTo > Region > Region > belongsTo > State > > City -> hasMany -> Houses > Region -> hasMany -> Cities > State -> hasMany -> Regions. > > In the case of "hasMany" relationships, thats where "unbindModel()" > comes in handy. That will limit the results returned in the dataset. > You'll see what I mean when you look at the index action of the > "houses" controller in that zip file. You can try removing the the > calls to "unbindModel()' and notice how that affects the dataset > returned. > > Here's what it will look like in your view: > > <?php foreach ($houses as $house): ?> > <strong>House:</strong> <?php echo $house['House']['title']; ?><br / > > <strong>City:</strong> <?php echo $house['City']['city']; ?><br /> > <strong>Region:</strong> <?php echo $house['City']['Region'] > ['region']; ?><br /> > <strong>State:</strong> <?php echo $house['City']['Region']['State'] > ['state']; ?><br /><br /> > <?php endforeach; ?> > > Hope this helps. > > - Dan --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
