<?php
$con = mysql_connect("db1","manycolors","L37dQrSW");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

$database = 'lgf_manycolors';
// some code

$sql = "SHOW TABLES FROM `lgf_manycolors`";
                        $result = mysql_query($sql);
                        if (mysql_num_rows($result) > 0) {
                                echo "<p>Available tables in " . $database . ":</p>\n";
                                echo "<pre>\n";
                                while ($row = mysql_fetch_row($result)) {
                                        echo "{$row[0]}\n";
                                }
                                echo "</pre>\n";
                        } else {
                                echo "<p>The database '" . $database . "' contains no tables.</p>\n";
                                echo mysql_error();
                        }

mysql_close($con);
?>