Dynamic sql count - all mysql database tables

mysql_count_all_tables.php

<?php 
mysql_connect("localhost", "root", "1234");

$banco = 'ecommerce';

$db_selected = mysql_select_db($banco);

$result = mysql_query('SHOW TABLES');
while($row = mysql_fetch_assoc($result)) {
	
	$resultTable 	= mysql_query("SELECT COUNT(*) FROM " . $row['Tables_in_' . $banco]);
	$rsTable 		= mysql_fetch_assoc($resultTable);

	if(strstr($row['Tables_in_' . $banco], 'carrier', true)) {
		$carrier[] = $row['Tables_in_' . $banco] . " Registros: " . $rsTable['COUNT(*)'];
	}
	

}

print_r($carrier);