you may want to check this: http://bakery.cakephp.org/articles/view/coding-a-self-join-in-a-cake-application
On Jul 14, 9:04 am, si-mon <[email protected]> wrote: > Hi All, > > I am creating a CRM application in cake php. In it, in my user table, > there are three levels of users viz. Director, Manager and Executive. > > I need to include a field "reports_to" > Eg: executive1 reports_to manager1 > executive2 reports_to manager1 > executive3 reports_to manager2 > executive4 reports_to manager3 > and so on... > > This means, the users table belongsTo (or hasAndBelongsToMany) the > same users table. > > Please help me to implement this... > > Thanks in advance... --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
