can't get SHOW TABLES to work

VisionsOfCody

I've been trying to use SHOW TABLES in a php script in the same way as i have successfully used DESCRIBE but it always returns as not being a valid mysql result resource

here's the code i've been trying

include("include_mysqlDetails.php");
$result_tablesquery = mysql_query("SHOW TABLES");
	while ($row_tablesquery = mysql_fetch_assoc($result_fieldsquery)) {
		echo $row_tablesquery['Tables_in__bambin_']."<br>";
	}

but it's the wrong syntax and i've been searching for an example but i can't find one

can anyone help ?

VisionsOfCody

oops my error

I wasn't using the same variable names - I had one "$result_tablesquery" and one "$result_fieldsquery"

now it works fine !