Alex Beston wrote: >>As above, set a UNIQUE index on the field, but use INSERT IGNORE to >>convert duplicate-row-errors to warnings. > > Yes, that worked quite nicely; I guess whats its doing is overwriting > whats already there. No, but the FM is your friend: <http://dev.mysql.com/doc/refman/5.0/en/insert.html> :: including info on `IGNORE` and `ON DUPLICATE KEY UPDATE`; highly recommended reading *before* using these statements... :-) FWIW! -- Hassan Schroeder ----------------------------- hassan at webtuitive.com Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code.