Compare 2 DB's

[rwilkin]

Hi,

I want to compare the tables from 2 mysql databases in a table.

This is what I have:

for($i=0;$i<$maxCount;$i++)
{
echo "<tr>"; // start row
//fist data square
if ($i < count($db1))
echo "<td>{$db1[$i]}</td>";
else
echo "<td></td>";

echo "<td></td>"; // middle 


//last
if ($i < count($db2))
echo "<td>{$db2[$i]}</td>";
else
echo "<td></td>";

echo "</tr>"; // end row
}

 

that will put make a nice table for me to see. What I'd like to do next is have all identical sql tables lined up.

So for e.g I have 2 arrays of table names that will look like this:

 

Databse 1Database 2

table1table1

table2[/td]

table3

table4table4

 

does that make sense?

Also is there a more elegant way of scripting what I have?