Hi, this is a way to find dupes with sql
SELECT id, year, COUNT(*) AS cnt FROM table GROUP BY id, year HAVING cnt>1 Lutz [EMAIL PROTECTED] (J. Wharton) writes: > Does anyone know of any built-in functions (either in PHP or MySQL) that can > search for duplicates in a table according to 2 fields (id and year)? > > Thanks in advance, > > J. Wharton -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php