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

Click counter to ignore traffic from search bots
I have a click counter on my site that...well, counts the number of clicks a link gets on the frontp

Guixt issue
Hello all,

We are experiencing the following problem with Guixt:

Some transact

While Problem
i am having a problem with a while statement here is the code
Code: [Select]<?php
sess

Only add new information from XML to MySQL
What I am doing, is taking a xml file, and adding the values to a database. However, what I want to

php/mysql problem
Hey all,

Problem: im trying to setup a shop where people can use a drop-down list to select t

how do i display data on a page from mysql
1 - do i use this code at the top of each of my page i wish to only alow access if there as been a s

Image resize
Hi again fellers

I managed to sort out the issues with the folder,

Final hurdle is th

form variables from database help.
Hi all,

I would like to have a form that gives you options based on the results of an mysql q

Retreiving objects from Sessions
Hi all,

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

start new row of pictures
on my site www.budstreasureauctions.com there is a featured auctions box that users will pay to get