Unable to retrieve data from multiple WordPress websites on same server

Would you mind if I just leave bread crumbs so you can solve this pazzle ?

  1. add filter
  2. ‘query’ hook
  3. $wpdb->prefix & local wpdb prefix
  4. value somewhere in *_options table
  5. remove_filter
  6. show values

Once one wpdb instance declared… you can reach any table in it (beware I said table in one DB). But you can’t do what you actually doing right now. YOU WILL GET a fatal error.

Other way is to parse wp-config.php of each site, make mysql connection, query everything, and show it… but that a lame-too-easy way….