> Thats exactly why I seperated these things into two tables. They don't > belong together in a semantical manner. User/group is only an example, > but it shows what I mean.
But you simply can't have an MTTP tree spread across tables, as the branches and their positions are instrinictly linked. It's like having a tree that can either start as an apple or a pear tree and depending on some random event one branch produces apples whilst a branch off that apple branch produces pears. your data model is fubar'd imo - sorry! There's absolutely no reason why you couldn't treat users at different levels in the tree differently. Say the root node is prime minister, those below are lords, below them are members of parliment, etc etc. Eg, a user _has_ a group of other users, and a user _belongs_ (in all instances except the prime minister) to another user. If you need groups to have unique names, then it's the groups that are in the tree, not the users. J -- jon bennett - www.jben.net - blog.jben.net 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 [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
