Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › General / Announcements › PHP and MySQL › 2 (or multiple) database connections?

2 (or multiple) database connections?

Thread began 2/19/2011 11:51 am by troyd | Last modified 2/22/2011 7:18 am by Jason Byrnes | 1044 views | 1 replies |

2/19/2011 11:51 am | #1 troyd

2 (or multiple) database connections?

I have a working site with a database handling several pages of records. Mostly CMS stuff.
Anyway, I have now created a shopping cart database for a new section of the site. But the new "Products" section will also need information from the first database.

A mistake on my part may have been creating a new database for the products.

Is it possible to have 2 database connections on one page? Or do I have to merge all the tables to one database? Or can I include the connection information for both in one connection file?

Both databases are on the same domain, in the same PHPMyAdmin.

Thanks,
TroyD

2/22/2011 7:18 am | #2 Jason ByrnesWebAssist

yes, you can have multiple database connections on the same page.

Just go to the database tab and create both connections there, then when creating the recordsets, choose the appropriate connection file first.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.