$dbConn = MySQL_Connect( "localhost", "root", "" ) or Die( "Error connecting to MySQL: " . MySQL_Error() ); MySQL_Select_DB( "aci" ) or Die( "Error selecting Database: " . MySQL_Error() ); $sSQL = "SELECT DISTINCT clientID, targetEmail FROM target"; // Select Unique values $resUnique = MySQL_Query( $sSQL ) or Die( "Error executing query: " . MySQL_Error() ); while ( $row = MySQL_Fetch_Array( $recUnique ) ) { $sSQL = "SELECT * FROM target WHERE clientID=" . $row["clientID"] . " AND targetEmail=" . $row["targetEmail"]; $recDuplicate = MySQL_Query( $sSQL ) or Die( "Error executing query: " . MySQL_Error() ); while ( $duplicates = MySQL_Fetch_Array( $recDuplicate ) ) { print( "Duplicate found: " . $duplicates["clientID"] . "<BR>\n" ); } MySQL_Free_Result( $recDuplicate ); } MySQL_Free_Result( $recUnique ); MySQL_Close( $dbConn );