Just thinking here of ways to remove the many HABTM tables I have in my db set up and thought of this and just wondering if this makes sense or is even possible. A normal HABTM table saves id user_id skill_id 1 1 2 2 1 5 3 1 6 4 1 9 5 1 12 Would it be possible to save the skill_id field as a single entry => 2,5,6,9,12 So if there was multiple HABTM they could all be saved into 1 table? users_selections table would look like id user_id skill_id option_id preference_id 1 1 2,5,6,9,12 2,5,8 1,2 THIS IS WHERE MY THOUGHT GETS CRAZY: If you extracted the skill_id in a before save from the array and saved it in a format like this 2,5,6,9,12, then when you need the info find it and make resemble how it looked before it was saved with afterfind or something to 're-assemble' it. I have 13 HABTM tables and if they could all be stored into 1 table that would be a much easier approach do you not think? Please let me know what you think, options, suggestions, call me crazy :) thanks Dave
--~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
