DELETE/IGNORE DUPLICATES
(Requires Database Support)

This function is Great for people generating leads!

About this function
This function allows you to specify if you wish to ignore/delete duplicate submissions posted on the form. Ignore means, it will simply send the form poster to the success page and no other actions will take place. Ie. The data will not be sent to the data file, no auto-response or results email will be sent, etc....

In summary, if you are using this feature and a duplicate form submission is found, it will be like the form was never submitted.


DELETE/IGNORE DUPLICATES VIA FLAT FILE

$delete_dups

Using the $delete_dups variable you can specify if you wish to ignore duplicate submissions posted on the form. Ignore means, it will simply send the form poster to the success page and no other actions will take place. Ie. The data will not be sent to the data file, no auto-response or results email will be sent, etc....

If $delete_dups is set to 1, all duplicates will be deleted/ignored. To process duplicate submissions as any other, set $delete_dups to 2. (2 IS THE DEFAULT & MOST COMMON CHOICE)

For example, if you DO NOT want to delete/ignore duplicate form submissions (DEFAULT & MOST COMMON): $delete_dups = "2";

OR - To delete all duplicates: $delete_dups = "1";

NOTE: A duplicate is determined by the email field.


DELETE/IGNORE DUPLICATES VIA MYSQL

$MYSQL_delete_dups

Using the $MYSQL_delete_dups variable you can specify if you wish to ignore duplicate submissions posted on the form. Ignore means, it will simply send the form poster to the success page and no other actions will take place. Ie. The data will not be sent to the data file, no auto-response or results email will be sent, etc....

If $MYSQL_delete_dups is set to 1, all duplicates will be deleted/ignored. To process duplicate submissions as any other, set $MYSQL_delete_dups to 2. (2 IS THE DEFAULT & MOST COMMON CHOICE)

For example, if you DO NOT want to delete/ignore duplicate form submissions (DEFAULT & MOST COMMON): $MYSQL_delete_dups = "2";

OR - To delete all duplicates: $MYSQL_delete_dups = "1";

If you chose to ignore/delete duplicates submissions, then you must also set the form field <input type="hidden" name="check_duplicate">. You must enter all MySQL fields you want to check duplicates each separated by a coma.

For instance, if you are writing form fields "email" and "phone" to MySQL fields "email" and "phone", and you want to check both for duplicates, then you would enter: <input type="hidden" name="check_duplicate" value="email,phone">