[Pangloss]

I have a MySQL 5 membership database which is populated via a form in the conventional way. I now wish to refuse any form submitted which contains a duplicate of an existing record and inform the user, preferably by way of another html page, that he is already in the database.

I have tried making the email address field a unique field and the result of this is a rather insignificant message on a blank page reading: "Duplicate entry 'member1@gmail.com' for key 2". If this was the thing to do I would like to make the message more informative and generally prettier.

Any suggestions guys?