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 '[email protected]' 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?
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 '[email protected]' 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?
Comment