Cannot get tables but can get db's

Anon

I have a Win2k server running II5 and aother machine running MySQL. I have set the section in the PHP.ini for mysql_host to the MySQL machine.

I can connect okay and display the list of database's fine but it will not let me display all the tables in a database I just keep getting:

Warning: Supplied argument is not a valid MySQL result resource in ../new/links.php on line 32

the code is below:

$db = mysql_connect("RAM");
$tb_list = mysql_list_tables($db);

$i = 0;
$cnt = mysql_num_rows($tb_list);
while ($i < $cnt) {
	echo mysql_tablename($tb_list, $i) . "\n";
	$i++;
}
mysql_close($db);

can anyone sort me out???

Anon

K, I am new at this, actually really new I just started yesterday, but i think that i might have found what you have done wrong. the mysql_connect command only connects PHP to a MySQL server, not to the database. so in order to get the Database "ram" you should try this.

$mysql_server = mysql_connect("NAME OF MYSQL SERVER");
$mysql_select_db("RAM", $mysql_server);
$tb_list = mysql_list_tables(mysql_select_db);

$i = 0;
$cnt = mysql_num_rows($tb_list);
while ($i < $cnt) {
echo mysql_tablename($tb_list, $i) . "\n";
$i++;
}
mysql_close($db);

This should work, i have not been able to test it because i cannot get either PHP or MySQL to work on my Win2k system, i have tried it with different software and it never seems to grab it.

I am probebly totally off, but i am just trying to help, remember, this is only my 2nd day playing with PHP and MySQL.

Anon

Sorry, RAM is the name of the machine, I have a database called "links"

It seems to be the mysql_list_rows that is causing the error:

$db = mysql_connect("RAM");
$select_db = mysql_select_db("links", $db);
$tb_list = mysql_list_tables($select_db);

$i = 0;

--> $cnt = mysql_num_rows($tb_list);

Sorry for the lack of info 🙁