I'm working on an application where people can sign up to use a service and can refer others into the network. I'm wanting to use a self-referential join table where I have one table with of course an ID and an associate id where that will join to a parent record within that table.
So if Jane referred in Tom then then Tom's associate id field would have Jane's id # in it. The I have several questions: 1) How do you set up a table that uses self-referential joins within CakePHP and using cake migrations. 2) How would you reference those associations within the model? 3) How would you save to the database using a self-referential join. Most of the posts on the user group have people using two different tables and to me that's not a self-referential join. I'll do some more searching. If CakePHP is a close port from Ruby on Rails then I guess I could look at some Rails examples to see how they are doing. I think they have acts_as_tree. Thanks, Tony --~--~---------~--~----~------------~-------~--~----~ 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] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
