title: List all tables within DB
body: <p>I am trying to show a list of all tables within my database </p>
  
  <p>I have the below code:</p>
  
  <pre><code> $result=mysql_query("SELECT TABLE_NAME FROM vogaldes_fuse.INFORMATION_SCHEMA.Tables ")or die('ERROR 315' );
   $num_rows = mysql_num_rows($result);
   echo "$num_rows";
  </code></pre>
  
  <p>However this does not show any results, instead i see <code>ERROR 315</code></p>
  
  <p>Also, I want to list the table names, how do I get these?</p>
  
  <p><strong>UPDATE</strong>
  I have managed to get the correct number of tables using the below:</p>
  
  <pre><code>$result=mysql_query("SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA LIKE 'vogaldes_fuse';")or die('ERROR 315' );
  </code></pre>
  
  <p>The last bit of my question still stand, how do I turn each table name into a string that I can then use to list in a <code>select</code> dropdown?</p>