MySQL db help

[incarnate]

Hi, I was wondering how to check if a database is empty. Thanks.

[incarnate]

bump

[laserlight]

There doesnt seem to be a mysql_num_tables() function, maybe you can make do with mysql_list_tables?

Conversely, you could use SHOW TABLES; via shell.

[incarnate]

Sorry, I meant if there was a way I could check to see if a table is empty?

[laserlight]

That's easier.
You could try

<?php
$query = mysql_query("SELECT * FROM tablename");
if (mysql_num_rows($query) == 0)
	echo 'Table is empty';
else
	echo 'Table contains rows';
?>