title: How to show all the tables from multiple databases
body: <p>How to select all the tables from multiple databases in mySql..
  I am doing the following steps but not able to achive the goal.</p>
  
  <pre><code>&lt;?php
  $a = "SHOW DATABASES";
  $da = $wpdb-&gt;get_results($a);
  
  foreach($da as $k){
  echo '&lt;pre&gt;';
  print_r ($k-&gt;Database);//prints all the available databases
  echo '&lt;/pre&gt;';
  $nq = "USE $k-&gt;Database";//trying to select the individual database
  $newda = $wpdb-&gt;get_results($nq);
  $alld = "SELECT * FROM $k-&gt;Database";
  $td = $wpdb-&gt;get_results($alld);
  var_dump($td);//returns empty array
  }
  ?&gt;
  </code></pre>
  
  <p>Please Help me </p>