Title: include 2 diff dbs in plugin function
Last modified: August 19, 2016

---

# include 2 diff dbs in plugin function

 *  [alsmith](https://wordpress.org/support/users/alsmith/)
 * (@alsmith)
 * [17 years, 6 months ago](https://wordpress.org/support/topic/include-2-diff-dbs-in-plugin-function/)
 * I have a function and am rewriting it to be portable. My functions is calling
   2 db tables, 1st it calls the db table in my DB.userdb then is to call the wordpress
   wp_users table.
 * In my function I gave global $config, $wpdb;
    then I select * from my $config[
   table_prefix]usersdb I then want to loop through the results to match values 
   in my wordpress wp_users table.
 * I have to use DB_name.wp_users in my second select to get it to work. I cannot
   get $wpdb->prefix.”users” to work it is only outputting the wp_users and it needs
   to include the DBname also.
 * Can anyone tell me what I am missing?
    Trying to do a quert from two different
   DBs without having to hard code either of the 2 db names in the select statements

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [NC@WP](https://wordpress.org/support/users/ncwp/)
 * (@ncwp)
 * [17 years, 6 months ago](https://wordpress.org/support/topic/include-2-diff-dbs-in-plugin-function/#post-864398)
 * You’re missing the fact that WordPress is not intended to work with multiple 
   databases. The simplest way to resolve your problem is to move your tables into
   WordPress’ database. Also, you are using a needlessly convoluted approach to 
   data lookups. Instead of first running a query on one table and then use its 
   results to issue a bunch of other queries to run on another table, you should
   consider issuing one query on both tables joined together (which, again, is very
   easy to do when both tables in question belong to the same database).
 *  Thread Starter [alsmith](https://wordpress.org/support/users/alsmith/)
 * (@alsmith)
 * [17 years, 6 months ago](https://wordpress.org/support/topic/include-2-diff-dbs-in-plugin-function/#post-864402)
 * I figured out a way to accomplish this so I thought I would post it.
    Before 
   I call the 2nd DB I did this. global $wpdb; $db=DB_NAME; $usertable = “db.”/$
   wpdb->prefix.”users”;
 * Now I have $usertable from WordPress I can use throughout my plugin and works
   fine.
    This proves to be a much easier method than combining the tables into 
   one DB. Well, for me anyway. Since this is not new installations it would take
   much more work to combine the 2 stand alone applications. If both apps were using
   the same database it would be a no brainer but since they were not it was. Oh
   well, maybe someone else will find this useful.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘include 2 diff dbs in plugin function’ is closed to new replies.

 * 2 replies
 * 2 participants
 * Last reply from: [alsmith](https://wordpress.org/support/users/alsmith/)
 * Last activity: [17 years, 6 months ago](https://wordpress.org/support/topic/include-2-diff-dbs-in-plugin-function/#post-864402)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics