PHP script to find Diffs in field in a table

db-field-diff.php

<?php

    $db = 'DBname';

    $localdb  = mysql_connect('localhost', 'root', '');
    $masterdb = mysql_connect('master', 'root', '');

    mysql_select_db($db,$localdb);
    mysql_select_db($db,$masterdb);

    $sql = 'SELECT * FROM user';
    $mrs = mysql_query($sql,$masterdb);

    $i = 0;
    $notfound=0;
    $differs=0;
    $same=0;

    while($row = mysql_fetch_array($mrs,MYSQL_ASSOC))
    {
        $i++;

        $sql = "SELECT * FROM user WHERE id=".$row['id'];
        $lrs = mysql_query($sql,$localdb);
        $lrow = mysql_fetch_array($lrs,MYSQL_ASSOC);
        if (!$lrow) {
          $notfound++;
          echo "User ".$row['id']." was not found\n";
          continue;
        }

        if ( $row['fname'] !== $lrow['fname'] )
        {
          $differs++;
//        echo print_r($lrow,1);
        } else $same++;
        echo("seq: ".$i.", id: ".$row['id'].", fname@master: ".$row['fname'].", fname@local: ".$lrow['fname']." \n");
    }
    echo "Not found: $notfound\n";
    echo "Differs: $differs\n";
    echo "Same: $same\n";
?>