I guess different tables is as bad a different databases. Why don't you have your 10 tables and have the city correlation via an city_id field? That is what I would do.
Greetings Anja -----Ursprüngliche Nachricht----- Von: cake-php@googlegroups.com [mailto:[EMAIL PROTECTED] Im Auftrag von bookme Gesendet: Mittwoch, 1. Oktober 2008 13:25 An: CakePHP Betreff: Re: Accessing Multiple database Thanks your reply! Each city specific datbase have 10 tables..how can i make them? suppose common database has brands table and city1 database has stores table, becuase every city has different stores and no realtion to other city. so making diffrent database for different city is good I think. Can any one help me? On Oct 1, 3:13 pm, techiguy <[EMAIL PROTECTED]> wrote: > sorry i mean to say one common database and have tables > city1,city2,city3 instead of separate databases?? > > On Oct 1, 12:31 pm, bookme <[EMAIL PROTECTED]> wrote: > > > > > Hi, > > > I am working on a highly dynamic web content site. > > This website have two types of data one is common data and second is > > city specific. The homepage has listing of all the available cities > > which then takes you to that specific cities page. All the code for > > a specific city is the same as any other city, the only difference > > is the data being pulled from the database only relates to that > > specific cities. > > > I want to make different database for every city and one common > > database. suppose this website have city1, city2, city3 then there > > will be 4 different database. > > common-database > > city1-database > > city2-database > > city3-database > > > Can I do my database design int this way in CakePHP? I tried for > > this but don't know how can I access multiple database with a single > > query in CakePHP? > > Please tell me what is better way making this city specific site? > > > Thanks- Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" 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 -~----------~----~----~----~------~----~------~--~---
