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

Combining refCursors and Summing
Given the following DDL:

CREATE TABLE FOODSALESTEST ("WEEKNBR" NUMBER, "ST

Require select-option functionality in Module Pool Programming
Hi Gurus,

I am doing a development by Module Pool on Warehouse Management. For that devel

Display certain image depending on time of year
Hi, I am new to these forums and would really appreciate some advice on a piece of coding I have don

Xml parsing
I need a suggestion about parsing xml with multiply parts like pervious...
i.e. different device

BIG file upload!
Hey guys!

I'm trying to upload a file, it works well with smaller files but with 60mb+, I get

Help with form post data and arrays
Hi all,

I am new to this forum... It has been awhile since i have worked with arrays, and i a

Retreiving objects from Sessions
Hi all,

I am getting really frustrated with storing and retreiving objects from a session. Bu

Storing the referrer in session... problems with tabs
Hello All

I am currently working on an ERP project based on the MVC methodology, when a user

Agency Business Process
Hi,

I don’t understand the process of the agency business in SAP.

In my

CHECH A STRING FOR ' " ' (DOUBLE QUOTES)
I am checking for delimiter (.!?) and if there is a " after a sentence then it should neglect a