show me

Anon

My trouble is:
I want to use a php-mysql command to show me how many tables in a selected DB.
But dont know how to do?Plz tell me.

khaine

$connection = @mysql_connect("localhost", "sandman", "tQ9472b")
or die("Couldn't connect.");

$dbs = @mysql_list_dbs($connection)
or die("Couldn't list databases.");

$db_list = "<ul>";

$db_num = 0;

while ($db_num < mysql_num_rows($dbs)) {
$db_names[$db_num] = mysql_tablename($dbs, $db_num);
$db_list .= "<li>$db_names[$db_num]";

// list tables on each database

if (($db_names[$db_num] != "mysql") && ($db_names[$db_num] != "tempdata")) {

	$tables = @mysql_list_tables($db_names[$db_num]) 
		or die("Couldn't list tables.");
	$table_list = "<ul>";

	$table_num = 0;

	while ($table_num < mysql_num_rows($tables)) {
		$table_names[$table_num] = mysql_tablename($tables, $table_num);
		$table_list .= "<li>$table_names[$table_num]";

		$table_num++;
	}

	$table_list .= "</ul>";
}	

$db_list .= "$table_list";
$db_num++;

}

$db_list .= "</ul>";

<HEAD>
<TITLE>MySQL Tables</TITLE>
</HEAD>
<BODY>

<P><strong>Databases and tables on localhost</strong>:</p>

<? echo "$db_list"; ?>

</BODY>

this will list the tables. it can be easily modified to just count them.

Mark.

Anon

Well,thanx all, i have solve the question.🙂
use the command mysql_list_tables add on while function.

Anon

my code is even easy:

<?php

$link = @mysql_connect("$DB_SERVER","$DB_USER","$DB_PASSWORD");
if(!$link)
mysql_die( );

mysql_select_db("$DB");
$no= mysql_list_tables ($D😎;
$i=0;
while ($row= mysql_fetch_array($no))
{
$i++ ;
}
?>

but not so strict,thanx for ur help 🙂