The DBs are identical, but on different servers. I'm not an expert at
MySQL (the db we're using) so I'm not sure if it has the capability of
doing cross server queries.
-John
On Nov 26, 12:29 pm, Rafael Bandeira aka rafaelbandeira3
<[EMAIL PROTECTED]> wrote:
> For sure that's a way to do that.
For sure that's a way to do that.
>
> Can I create a model that will show me a list of all users in Ohio and
> Kentucky?
>
Are both dbs on same host and can they be accessed by same app's db
client and therefore be used in a same sql query?
--~--~-~--~~~---~--~~
If I have more than one database with identical tables, is there a way
for CakePHP to combine them?
Example:
DB1 has information for Ohio
DB2 has information for Kentucky
Both databases have a table that contains a list of Users (let's
assume that the primary key was setup so that there wouldn'