Anyone? Sorry, I am just stuck. If there was some way in cake to specify an alternative key it is searching for in the foreign table, I think that may solve my problem. Thanks.
Jim. On Jul 31, 1:55 pm, Jim Newfer <[EMAIL PROTECTED]> wrote: > Hello everyone, > > Last resort post, I am stuck. What I have done is create a "friends" > system in my app. Although it is mildly tricky because the friends are > the same thing as users, just using an alias. > > My tables look like this right now (only relevant information shown): > > Users: > Id > > Fans_Users: > fan_id > user_id > > Fans: > id > fans_info > > The fan is just an alias for another user. I have the HABTM > association set up fine and dandy. But what I cannot seem to get to > work no matter what I try, is get the user infomation to be be pulled > up with that fan. For example, User 67 has two fans, users 45 and > users 46. Not when I query for User 67, his two fans are shown, users > 45 and 46. BUT, I want users 45 and users 46 information to be shown > as well. I have tried all sorts of combinations of hasOne/belongsTo in > the fans table to get the fan to link to some user info. Even tried > adding a fan_id to the user table, (which is the same thing as their > id) And linking it to that. Problem is, it is matching the Fan.id to > the fan.user_id which is obviously a problem. I was thinking if I > could somehow modify the primary key it is searching for in the local > table, it could work (instead of matching the Fan.id to the User.id, > match the Fan.fan_id to the User.id) > > I am really stuck here, has anyone attempting anything similar? > > Thanks. > > Jim --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
