Get Number of Rows in a Mysql (all tables)

Mysql Query - Get Number of Rows in a Mysql Database Table
get count rows foar all tables - use TABLE_ROWS and TABLE_NAME from information_schema:

$query = "select TABLE_NAME,TABLE_ROWS from information_schema.tables where table_schema = 'my_data_base' ";
$result = mysql_query($query);
while ($row =  mysql_fetch_row($result)) {
$rowcount[$row[0]] = $row[1];
}
print_r($rowcount);

----------
una dintre solutii si cea mai rapida ! * ma gandesc ca poate mai are cineva nevoie de asa ceva !