On Mon, May 10, 2010 at 8:03 AM, Niel Archer <not@xxxxxxxxxx> wrote: > Hi > > As this is not a PHP question and in particular not Windows' related > PHP question, I'll keep my reply brief. > > If you had a unique index defined, duplicates wouldn't be allowed. Then > you would only have to add IGNORE to the INSERT to prevent warnings > being generated. > http://dev.mysql.com/doc/refman/5.1/en/insert.html > > I would suggest INSERT ... ON DUPLICATE UPDATE field = field instead of IGNORE(because IGNORE can suppress other errors), but you are right about that the unique constraint. Tyrael
