Well I wouldn't make different Database's unless you really really must! Instead stick with 1 DB, but more tables in the DB!
-------- your thought 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 -------- Well from what I see it is almost finished .... just miss writen so how about just calling all those tables (which would be in a different DB by you) city1_xxx city2_xxx city3_xxx And change the Prefix (implimented in CAKE) in your code to what you need ;-) Finished Querying between them is then a piece of Cake since normal Join's can be used between the Tables This also saves a LOT of Queries which you be needed to get information out of every single DB one by one ... Greetings Oliver On Oct 1, 5:56 pm, "Liebermann, Anja Carolin" <[EMAIL PROTECTED]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---