Number of tables...

[Anon]

How many tables can there be in one MySQL database? My site creates tables on the fly for new members...

Sander Voorn

[Anon]

while(mysql_list_tables("database"))
$bar++;

print "$bar tables in the database";

Hope this helps

Andreas

[Anon]

This is not what she asked.
The number of tables in a mysql database is huge.
For exact numbers, look at the mysql website.

BTW Andreas:

$result=mysql_list_tables("database");
echo mysql_num_rows($result);