Continue, unique value error

[eluser]yigitozdemir[/eluser]
Hi,I am inserting values to database, i have a table with two columns id,mail

But generally same addresses trying to be inserted. And codeigniter shows me error
Error Number: 1062

Duplicate entry

how can i continue on errors?

Thanks for advices!

[eluser]yigitozdemir[/eluser]
oh guys, i saved the problem, i changed the database configuration file $db['default']['db_debug'] to FALSE.
THX

[eluser]CroNiX[/eluser]
Simple with MySQL. Look up

Code:

INSERT ... ON DUPLICATE KEY UPDATE

http://dev.mysql.com/doc/refman/5.0/en/i...icate.html

[eluser]yigitozdemir[/eluser]
Thank you that works more efficiently