Show Mysql Database Table Information

if(file_exists("core/config/config.inc.php")) {
include "core/config/config.inc.php";
$conn= mysql_connect($database_server, $database_user, $database_password) OR die('Connection error');
$database= $dbase;
mysql_select_db($database);
$sql1= 'SHOW TABLES FROM ' .$database;
$res1= mysql_query($sql1) OR die('Query 1 error:<br />' .mysql_error());

echo '<table border=1 cellpadding=1 cellspacing=0 width="90%">';
while ( $row= mysql_fetch_row($res1) )
{
    echo '<tr>';
    echo '<td valign="top" align="center">' .$row[0]. '</td>';
    echo '<td>';
    $sql2= 'SHOW CREATE TABLE ' .$row[0];
    $res2= mysql_query($sql2) OR die('Query 2 error:<br />' .mysql_error());
    while ( $table_def= mysql_fetch_row($res2) )
    {
        for ($i=1; $i<count($table_def); $i++)
        {
            echo '<pre>' .$table_def[$i]. '</pre>';
        }
    }
    echo '</tr>';
}
echo '</table>';
}