On Thu, Oct 2, 2008 at 5:13 PM, ORCC <[EMAIL PROTECTED]> wrote: > [..snip..] > > Id City_Id Property Value > 1 1 "greeting" "HELLO" > 2 2 "greeting" "HOLA" > 3 3 "greeting" "CIAO" > 4 1 "contact" "[EMAIL PROTECTED]" > 5 2 "contact" "[EMAIL PROTECTED]" > 6 3 "contact" "[EMAIL PROTECTED]" >
Instead of the above table, it might be an idea to create a "properties" table with: Id Property 1 "greeting" 2 "contact" 3 .... .. and a HABTM table: city_id property_id value 1 1 "HELLO" 1 2 "[EMAIL PROTECTED]" 2 1 "HOLA" 2 2 "[EMAIL PROTECTED]" etc ... - Gonzalo --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
