hi
i was wondering if there was a mysql function that counted the number of tables in a database.
if anyone knows of such a command that would be great.
thanks
mysql count tables in a database
Moderator: General Moderators
There's no single function that can do it, but it can be done.
Code: Select all
//Stuff to connect to database
$rsTables = mysql_query("show tables", $databaseConnection);
$intNumberOfTables = mysql_num_rows($rsTables);