Forums

Please write a review for the extension you are using on the Joomla extensions directory before posting a new question as we are being spammed by many negative reviews.

Thank you for your support!

Joining External Database with Joomla Database

webbusteruk 02 Jan, 2019

Is it possible to join an external database (on same server) with Joomla's database?

It seems that we're able to load the external database, however adding a new model within the read_data function only displays the same external database's tables.

GreyHead 02 Jan, 2019

Answer

Hi webbusteruk ,

You can't access two different databases with a single query; you can use two queries and then merge the results using custom PHP.

Bob

webbusteruk 02 Jan, 2019

Doh! That makes sense.

This topic is locked and no more replies can be posted.

2Checkout.com

2CheckOut.com Inc. (Ohio, USA) is an authorized retailer for goods and services provided by ChronoEngine.com