[SOLVED] Maintaining several different DB connections in same script?

[kernelgpf]

Is it possible to interchangeably query two databases at the same time in the same script, and use+store resources?

 

If so, how?

[calabiyau]

I've managed to do it before, even with nested loops between two databases..ie..querying one and while looping through the results array using those results to query another and it worked fine.  but maybe there is a better way to do that type of thing.

[kernelgpf]

How did you do it?

[hvle]

yeah why not?

 

php is not designed to handle 1 single db connection.

In fact, you can have multiple connection to different kind of db, ie. oracle, postgre, myslq ...

 

If you have multiple connection, you must specify which connection to be used when calling db function, otherwise, php will use the first available connection and it could be a wrong one.

 

 

[kernelgpf]

Okay, thanks.

[calabiyau]

It was pretty simple actually, just set two different var's to the databases.  Select the first one, run your query then within that query select the second one and run your new query.

[kernelgpf]

Wait... how do you specify which DB variable to use?

[kernelgpf]

Would I have to connect, query, disconnect, connect to the second DB, query, disconnect, etc.?

[dj-kenpo]

disconnect at the bottom of your page when all is said and done.