MySQL Table Names in PHP DropDown

[kool_samule]

Hi Chaps,

 

I'm trying to get a list of MySQL table names in a PHP/HTML Select List/Menu with the value of the Select Option being the table name.

 

I have this as a starting point, but can't figure out how to get the values into the Select.

 

$result = mysql_query("SHOW TABLES FROM 'DATABASE'");

while($table = mysql_fetch_array($result))
  {
  $tables[]=$table;
  }

Any help would be sweet. .

[marcus]

<?php
$sql = "SHOW TABLES FROM database";
$res = mysql_query($sql) or die(mysql_error());

echo '<select name="tables">';
while($row = mysql_fetch_row($res)){
echo '<option value="'.$row[0].'">'.$row[0].'</option>';
}
echo '</select>';
?>

[kool_samule]

sweet, just what i'm after, i'm guessing that you could do something similar with COLUMNs as well as tables. . . . .many thanks!

[marcus]

Yep, but instead your query would look something like

 

$sql = "SHOW COLUMNS FROM table_name";

[kool_samule]

Got it, cheers dude