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

Splitting Attributes
SQL> SELECT I_NAME, substr(I_NAME,1,instr(I_NAME,'O')) "First part",

substr(I_NAME, IN

Restricted access to sub-folder in iis6 doesn't work?
Basically I'm trying to add restriction to sub-folder (which contains pdf) in web.config for iis6 as

RadioButtonList item spacing
I have a RadioButtonList and I can't put any spacing between the items. They are arranged verticall

Delete all from a table
I can not get the following code to work. If I run the sql statement in the db it will delete all t

Does deleting the spmlog directory critical?
Hi Everyone,

Please, hope you could help me. We're having problems with the SAP backup. I

Variable uses and placement
I'm new to PL/SQL and am trying to learn about variable valid uses/placement (any pointers to any do

what does this mean? +=
is anyone able to explain what this code is saying?

i had it written for me awhile back and n

Passing JS to PHP
So I have the following
Code: <?php
getdetails(?><script type="text/

PHP webpage & array print issue
I have this code running, and it works perfectly … however, see my bottom bit about what I see

Certain files upload, while others do not
I want to read the data from an uploaded file. Not sure why, but it only uploads for certain files.