\n";
$r = sqlUpdate("clientdat", "cCode='', fName='',lName='',address='',city='',csid=''", "tid='{$_REQUEST['fixdupDelete']}'");
echo $r['q']." \n";
}
else if (!empty($_REQUEST['fixdupNew']))
{ echo "Create new client based on {$_REQUEST['fixdupNew']} \n";
}
else if (!empty($_REQUEST['fixdupMove']))
{ $currentDat = mysql_query("select * from clientdat where tid='{$_REQUEST['fixdupMove']}'", $mLink);
$clientDat = mysql_fetch_assoc($currentDat);
$newDat = mysql_query("select * from clientdat where fName = '{$clientDat['fName']}' and lName = '{$clientDat['lName']}' and cCode != '{$clientDat['cCode']}'", $mLink);
}
$dupList = mysql_query("SELECT count( * ) , cCode FROM `clientdat` where cCode != '' GROUP BY cCode HAVING count( * ) > 1", $mLink);
$numDups = mysql_num_rows($dupList);
if ($numDups)
{ //echo "There are $numDups duplicate cCodes \n";
while ($dup = mysql_fetch_assoc($dupList))
{ echo "\n";
echo "{$dup['cCode']} \n";
$dups = mysql_query("select * from clientdat where cCode = '{$dup['cCode']}' order by tid", $mLink);
// echo "select * from clientdat where cCode = '{$dup['cCode']}' order by tid \n";
echo "
\n";
echo "
\n";
echo "
Name\n";
echo "
TID\n";
echo "
Alts\n";
echo "
SO's\n";
echo "
\n";
echo "
\n";
while ($dupDat = mysql_fetch_assoc($dups))
{ $cList = mysql_query("select * from clientdat where fName = '{$dupDat['fName']}' and lName = '{$dupDat['lName']}' and cCode != '{$dup['cCode']}'", $mLink);
$matchCnt = mysql_num_rows($cList);
$orderList = mysql_query("select * from headers where fName = '{$dupDat['fName']}' and lName = '{$dupDat['lName']}' and cCode = '{$dup['cCode']}'", $mLink);
$orderCnt = mysql_num_rows($orderList);
echo "
\n";
echo "
{$dupDat['lName']}, {$dupDat['fName']}
\n";
echo "
{$dupDat['tid']}
\n";
echo "
$matchCnt
\n";
echo "
$orderCnt
\n";
echo "
\n";
echo "
\n";
}
echo "
\n";
}
}
else
{ echo "No duplicates found \n";
}
?>