[RESOLVED] Show records in different DBs

eVrn

I am trying to show how many records are in each db. I have generated a list of dbs using this:

$result = mysql_query("SHOW tables", $db);
while($row = mysql_fetch_row($result)){
	echo $row[0];
}

This works perfectly and I want to add the number of records in each db displayed next to the db name. And I would even like to add a field value if I can. I definitely need some direction on this.

I hope to get the output to look like this:

database 1 - 12 records - updated 1/1/07
database 2 - 3 records - updated 1/2/06

Where currently all I have is:

database 1
database 2

As always, THANKS!

maxpup979

In your while loop, you can just run a count query on each table--ie:
$q2="select count(*) from $tablename"; then echo those results.

eVrn

I have been hacking at it and can't come up with a working code. Could you offer a more direct example? This is what I have come up with and it only shows the table name, but does not count or display the number of records. I THINK my issue is picking the table to count rows, but I am not sure if there are other issues BEFORE that.

<?

$result = mysql_query("SHOW tables", $db);

$query2 = "SELECT COUNT(*) FROM $result";
$result2 = mysql_query($query2);
$count = mysql_result($result2,0,0);

echo "<BR><BR><B>Current Tables:</B><BR>";
while($row = mysql_fetch_row($result)){
	echo $row[0]. " has " .$count[0]. "records.<BR>";
}
?>

Thanks!