I know I can assign 2 databases through codeigniter. Is there a way to tell the query tags which database to pull the information from? I'm having to pull data from an external database.
No. EE is set-up to check a single database. But you can add additional tables to that database as you see fit, and use QUERY module to access data out of them. For example, when we add custom tables to a solution for a client, we've done things like zip_code, counties, irs_data, etc. We use a prefix other than
exp and add them to the same database. You don't need the prefix, but it will keep the tables grouped together. So say,
That works well. We've also run secondary apps on the same database, using different prefixes. You may end up with a lot of tables, but EE's QUERY can access any of the tables.