Menu a tendina con elenco tabelle

[ttcc]

<?php 
include('connessione al tuo db');
?> 
<form> 
<select> 
<?php 
$sql = "SHOW TABLES FROM $variabiledeltuodatabase"; 
$result = mysql_query($sql);     
   if (!$result) 
           {
             echo "DB Error, could not list tables\n";
          echo 'MySQL Error: ' . mysql_error();         
              exit;     
           }  
while ($row = mysql_fetch_row($result)) 
     {
       echo "<option value\"\">$row[0]</option>"; 
      } 
?> 
</select> 
</form>

testato e funziona bene