how to populate dropdown with database names and table names?

[esandra]

I'm using mysql and php..I'd like to see how the query should go if I want to display the existing database names on a dropdown, same thing with the table names

[anups]

To show all databases

 

$con = mysql_connect("localhost","root","");
$result = mysql_query("show databases");
$db_str = "<select>";
$db_arr = array();
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){
//echo $row['Database']."<br>";
$db_str .= "<option>".$row['Database']."</option>";
$db_arr[] = $row['Database'];
}
$db_str .= "</select>";
echo $db_str;