I have read these and tried a couple ways already. The difference here is that city_id,secretquestion_id are part of my main table and my controller is on the main table. Where as in that material, user_id (of the main table) is part of the secondary info table (so user_id is foreign key).
That's where my $this->user->find() is failing to retrieve the data from secondary table. -BC On Feb 20, 5:00 pm, Tilen Majerle <[email protected]> wrote: > if you have relations in models created, than this should be automatically > > so, probably > User BelongsTo City > Secretquestion belongsTo City > > City hasMany User > City hasMany Secretquestion > > http://book.cakephp.org/2.0/en/models/associations-linking-models-tog... > > read here how to read data :) > > -- > Lep pozdrav, Tilen Majerlehttp://majerle.eu > > 2012/2/20 Blues Clues <[email protected]> > > > > > > > > > Hi > > I want to use cakephp model behaviour to do this. Can you help? > > > I have a user table which stores id(s) for city, secretquestion etc., > > so my 'user' table has city_id and secretquestion_id and the actual > > names/texts for these are stored in City & Secretquestion tables > > respectively. > > > Now, I am coding UsersController. When I read my User table, I get > > these IDs obviously. But I need to retrieve these names (City Name, > > Secretquestion Text) for subsequent use. > > > How can I do that? Can someone shed light on the steps involved? > > > I can simply write a SQL and do that but I want to utilize CakePHP > > Model functionality and handle this the CakePHP way. > > > Thanks > > -BC > > > -- > > Our newest site for the community: CakePHP Video Tutorials > >http://tv.cakephp.org > > Check out the new CakePHP Questions sitehttp://ask.cakephp.organd help > > others with their CakePHP related questions. > > > To unsubscribe from this group, send email to > > [email protected] For more options, visit this group > > athttp://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
