I have found many great examples for associations but I haven't find and example for multi users relate to one project with different title for each user
I have table users with the fields ( id, username, password, email, name) and table projects with fields ( id, team_id, project_title, status) and table teams with fields (id,manager, vice, member, supervisor) the project have one team ... and user can be manager or vice or member or supervisor but he can't fill more than one title in each team in MySQL lang ... projects one2one teams ... and teams one2many users I can't define which association function in cakephp is many2many or one2many or one2one also ... $hasAndBelongsToMany wont works ... as I have understand ... cakephp have specific needs for HABTM relationship to work ... which I need a table with the name (users_projects) and have 2 fields only (user_id, and project_id) but I need more information to include in the relationship !! I have tried to do this ... projects [belongsto] teams ... teams [hasOne] projects ... and users [hasMany] teams ... but scaffold doesn't show me what suppose to be How I can make custom mySQL query to define the relationship and how to use it in controller ! .. and is there any who telll me what to do to have the perfect relationship ! --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
