maybe double entries or not

slimjim

I have a problem where if there is an email found in database
it shouldn't do a insert, but for some reason people are still able
to submit a link, even if their email is found.

Heres my problem also, when I test it, it works fine and I can not
add a link because it found my email address.

How could someone be going around this ?

Or it also looks like for some reason, doulbe entries are happening to me.
Should be doing something different ?

$query="select email from list where email='{$_POST['email']}'";
$result = mysql_query($query) or die( "ERROR: " . mysql_error() . "\n");	    

if (mysql_num_rows($result) == 0) {
//Do insert
} else {
		header ("Location: email_fail.php");
}

slimjim

Well not sure why the query isnt working right cause I just added :

     header ("Location: success.php");

right below the insert and people still can add 2 entries

intenz

Awkward. :bemused:

Try...

if (mysql_num_rows($result) <= 0) {

slimjim

Tried that too and they are still able to add link twice.. driving me nuts cause the code is simple I thought.

Roger_Ramjet

Add a unique index and they won't be able to make multile entries.

Echo out the query to see what is in the $_POST['email']

slimjim

what do you mean by unique index ?

I echoed email and i cant not add 2 entries cause it finds mine, but other people, and not all, but most are able to add 2 entries even if their email is in there.