list table names and row counts in a database

[webgodjj]

Hi,

I am trying to list all the tables with their row counts in a databse... I have been racking my brain on how to do this. So far I have figured out that there is a function mysql_list_tables(), however, this is depreciated and should not be used. So this is my code so far, but I have no idea on how to include my while statments to output a list like so

TABLE NAME  COUNT
table1           1204
table2           1053
table3           5042

<?php
include ("config.php");
if (!mysql_connect('$host', '$user', '$pass')) {
** echo 'Could not connect to mysql' . mysql_error;
** exit;
}
$result=mysql_query('SHOW TABLES FROM $db') or die(mysql_error);
?>