<?php

$db_host = '';

$db_name = '';

$db_user = '';

$db_pass = '';


$result = mysql_connect($db_host,$db_user,$db_pass);

if(!$result)
{
    die(mysql_error());
}
else
{
    echo "Successfully Connected to $DbHost<br>";
}

$dbget = mysql_select_db($db_name);

if(!$dbget)
{
    die(mysql_error());
}
else
{
    echo "$db_name was selected!<br>";
}

$query = mysql_query('SHOW TABLES FROM '.$db_name);

if(!$query)
{
    echo "Could not run query to list tables";
}
else
{
    while($row = mysql_fetch_row($query))
    {
        echo "Table: ".$row[0]."<br>";
    }
}


$dbclose=mysql_close($result);

if(!$dbclose)
{
    die(mysql_error());
}
else
{
    echo "db closed!<br>";
}

?>