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 [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 -~----------~----~----~----~------~----~------~--~---
