viewing tables

[natman3]

I am wanting to view all my tables within my dba. I want to create a form that will list all of them buy placing the table names in the dropdown form menu. Does anyone know a script that can do this. The code that I have thus far is as follows. I have also included the form that i am wishing to use to display the table names.

function getTableName(){
Global $connection;
hookUpDb();
$query = "SELECT * FROM ozarkDB";
$result = mysql_query($query,$connection);
while ($row = mysql_fetch_row($result)){
$id = $row[0];
$header = unFormatData($row[1]);
print("<option value=\"$id\">
$header</option>\n");
}
mysql_free_result($result);
mysql_close($connection);
}

<form action="admin.php" >
<table class="formBg" align="center" width="40%" border="1" cellspacing="0" cellpadding="2">
<tr valign="top">
<td width="43%">Choose File here</td>
<td width="57%">
<select class="dropdownMedium" name="selArticle">
<option selected value="0">--- Choose File here ---</option>
<?php getFileName(); ?>
</select>
<input class="medium" type="hidden" name="txtId" value="<?php print(unFormatData($row[0])); ?>">
</td>
</tr>
</from>

[nemonoman]

The query you want is "SHOW TABLES"

function getTableName(){
Global $connection;
hookUpDb();
$query = "SHOW TABLES";
$result = mysql_query($query,$connection);
while ($row = mysql_fetch_array($result)){
$tablename= $row[0];
$header =$ tablename;
print("<option value=$tablename>
$tablename</option>\n");
}
mysql_free_result($result);
mysql_close($connection);
}