http://www.adobe.com/devnet/dreamweaver/articles/beginners_databases_03.html
On May 3, 9:50 am, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > You are asking is how to set up relationships. If you don't know how > to create basic relationships, then you need to read cake manual, and > then go through the blog tutorial. You can do both in about 3-4 hours. > After that, try setting up your relationships; If you still have > trouble at that point, come back here and ask for help. > > There are plenty of people willing to help here, but you need to know > the basics first. > > On a different note: I think you would find it easier to keep all of > you content in one table, rather than having one table for each > language. Just add a field to identify the language. > > page.id > page.name > page.language > page.header > page.body > > Now when some one goes to the "home" page, you can simply query > page.name=home AND page.language = users_language > > This way you don't need to bind and unbind models, and you don't need > to create a new table every time you add a new language. > > good luck, > cook > > On May 3, 9:14 am, Anton Morrison <[EMAIL PROTECTED]> wrote: > > > Hi > > > I have a table with a page title and body. the title and body are > > integers that link to a table with there content value (so i can have > > different tables for different languages). Is there a relationship i > > can set up to get the content values in one query? > > > at the moment i get the integer values then go through the content > > table and get the text values, but this means extra trips to the > > database. > > > thanks in advance. > > > Anton Morrison > > [EMAIL PROTECTED] --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---