[RESOLVED]How to output tablenames in specific databae using php

[tony007]

hi all. Could any one show me how to display table names of a specific database using php? I tried the following but didn't output any thing!!

<?php

$server   = "localhost"; // MySQL hostname
$username = "root"; // MySQL username
$password = "?????"; // MySQL password
$dbname   = "kingkong"; // MySQL db name

$db = mysql_connect($server, $username, $password) or die(mysql_error());
      mysql_select_db($dbname) or die(mysql_error());

$sql = "SHOW TABLES FROM kingkong ";

$fp = fopen("query.txt", "w");
fwrite($fp, $sql);
fclose($fp);      
$result = mysql_query( $sql );

while($row = @mysql_fetch_array($result)) {

?>
<?php echo $row["tables"] ?>

<?

}

?>

[the182guy]

'tables' isn't the field name that is returned by SHOW TABLES it's 'Tables_in_DBNAME'

so use $row[0]; or $row['Tables_in_kingkong'];

[tony007]

thanks that $row[0] fixed it!