If a record matches an existing record do nothing

Posted on 16th Feb 2014 07:03 pm by admin

So I don't know if I should put this here or in mysql, but what my script is for is for people to add their emails to our mailing list. Pretty simple, I got that working. But what I want it do now is that if somebody puts their email in and their email is already added to our database then it doesn't do anything. but if their email isn't in our database then it will add it.

So basically stop duplicate records. Is there any way to do this php? I'm sure there is, its just not coming to me.

Your Answer:

Login to answer

Other forums

HTML Form Server Side Validation
Hi, Im new here, im currently doing a website for a friend, and I have designed using snippets from

how to export excel file in same server
My first post - php newbie, so appreciate your support.

I'm currently using headers to save w

fwrite error
Hi All,
Does anyone know what is causing the error in this code?

Code: <?
$error

Image resize
Hi again fellers

I managed to sort out the issues with the folder,

Final hurdle is th

dinamic "textboxes"?
Ey all, my first post here, i hope its not a hard one

I display mysql results in a table

Stuck with preg_replace
Hi,

I'm trying to use preg_replace to remove part of the IP address submitted using a form on

Help with explandable category tree
I have the below query:

SELECT l1.id as lev1_id,l2.id as lev2_id,l3.id as lev3_id,l1.categ

foreach iterator
Hi Guys
Does the foreach loop have an inbuilt iterator ?

Could Someone Please Debug This?
I was wondering if someone could debug this script for me. I realize it's not the tidest script (and

Preventing blank or already entered values
Im trying to learn how to place a read file line by line and prevent duplicate entries and also BLAN