in reply to Re: Checking for Dupes in MySQL
in thread Checking for Dupes in MySQL

I agree with grinder here. I would think this is the best method of inserting unique rows into a database.

The table should have the unique constraint enabled to enforce the integrity. Good application design would *not* have the integrity enforced externaly

In my mind it would be better to make to graceful calls to the database, rather than making one and traping any errors.