[Phpsig] SHOW TABLES using php?

[Paul VandenBosch]

How would you write a script to show the tables in a database using php?

I think I have been able to connect to mysql without an error, now I would
like to find out which tables are in my database.
How would you do a mysql> SHOW TABLES; command using php?

<?php
include("common.php");

//set up SQL connection
	$connection = mysql_connect($server, $user, $password);

	mysql_select_db($db, $connection)

//insert script



//end script

	mysql_close($connection);
?>



-- 
Paul VandenBosch
Guide to Sailing and Cruising Stories
http://cruisenews.net