Php and database tables

[jokerofsouls]

I wanted to know how i could make a script that it will, look at the database and it will be yes or no if the table is or is not there, if you could please help. thanks

[wildteen88]

Use the SHOW DATABASES sql command to get all the databases that currently exist. Then use a while loop to loop through the available databases, eg

 

$sql = 'SHOW DATABASES';
$result = mysql_query($sql) or die ('MySQL Error: ' . mysql_error());

$my_database = 'YOUR DATABASE NAME';

while(list($db_name) = mysql_fetch_row($result))
{
    if($db_name == $my_database )
    {
        echo $my_database . ' exists!';
    }
}