Manaaging Duplicate entrys

[nevets_anderson]

Hi

I have a database with a php front end that is using email address as a unique identifier. At this point it won't let you create a record with the same email address (It can only be used once) but I'm not getting any error message back from my php / mysql project.

I had a play about with the database with php my admin and it responds with

this error (which is the sort of behavior I want)

#1062 - Duplicate entry '[e-mail]' for key 2

How would I go about generating a similar error message from my project?
Could anyone point me towards some simple examples?

Thanks in advance

Nevets aka Steve

[dagon]

mysql_error()