Slect Database from Dropdown

[jemq]

Here is hopefully a simple question for an experienced programmer but maybe not for a newbie like me.

I wish to create a dropdown box of my SQL databases so I can choose which one to connect to. I know how to connect etc but I need to knwo how to list the tables in an SQL database and the databases themselves so I can choose which ones to connect to.

Thanks

Jemq

[devinemke]

echo '<select name="database">';
$result = mysql_query('SHOW DATABASES') or exit(mysql_error());
while ($row = mysql_fetch_assoc($result)) {echo '<option value="' . $row['Database'] . '">' . $row['Database'] . '</option>';}
echo '</select>';

[jemq]

Thanks for that, that show me the Databases available.
What I also need is that when a Database is selected a second dropdown will provide a list of tables contained within that Database.

Thanks

[devinemke]

same basic idea but use a SHOW TABLES query. read up on the SHOW SYNTAX.