Shaf,
Try this query instead:
$sql = “SHOW TABLES”;
Your connect string should already connect you to the MySQL DB and you should have a database string which defines which database to act upon. “SHOW TABLES” is a basic sql statement to show all tables in your current database.
Steve