I have a simple form that has one field:
And my forms action is: email.php
In email.php, i just insert the email address to a table called:
and a database called:
What i want to know is, using PHP how can i check for a duplicate value in the table before trying to insert. If i insert then the user would get the message:
You could not be added: Duplicate value, "firstname.lastname@example.org" for Key 1
Is there a way i can check first then say if it is duplicate?