easy list tables ?, why won't this code work?

[Anon]

<?php
$db = mysql_connect("hostname","username","password") or DIE("Sorry, couldn't connect");
mysql_select_db("database",$db);
$result = mysql_list_tables("database");
$names = mysql_tablename ($result,$i);
echo $names[$i] . "<BR>";
?>

The above code displays the FIRST character of the FIRST table listed in the database, doesn't list all of the table NAMES like I am wanting.

What is wrong with the code? Figure it is minor, but can't track it down. Thanks........

/frank

[Anon]

Frank,

change this: $result = mysql_list_tables("database");

to this: $result = mysql_list_tables('database');

Ya need signle quotes there, buddy

Hope this helps,
Lazzerous

[Anon]

thanks, that worked! simple things that get 'cha...:-)

/frank