PROS! Help with simple INSERT statement!

[brianb]

Hello Pros,

I have a quick question here. Basically, I want to have multiple forms in one page where a user can submit their e-mail address to each form on the page, but cannot submit their name more than once to each form.

So, I guess but doing the INSERT I have to check for duplicates.

My table is setup where each form has an ID. So I need to do dulpicate checking on the e-mail address, but only for the form they are submitting to. make sense?

Here's my code which seems to have some flaws:

$query = "SELECT * FROM Data WHERE email='$email' AND listID='listID'"; 
$result = mysql_query($query); 
if (mysql_num_rows($result) != 0) { 
 echo "<b>Hey!</b> You've already entered this contest with the e-mail address:<br><span class='main'>$email</span><br><br>While we DO accept multiple enteries to one contest,<br> you do have to use a unique e-mail address with each entry!<br><br>If you'd like to enter the contest again, please enter with a different e-mail address!<br>GOOD LUCK!<br><br><A HREF='javascript:window.history.back();'><img src='/media/news/clickhere.gif' width='76' height='14' align='absmiddle' border='0'></a> to go back to the contest page.<br>";
}
else {

$sql = "INSERT INTO Data VALUES( \"$ID\", \"$name\", \"$email\", \"$extra\", \"$listID\" )"; 

$res = mysql_query( $sql );

echo "<span class='main2'><font color='#000000'>THANKS FOR ENTERING!</font></span><br><br>Your e-mail address of: <b>$email</b> has been entered into the drawing!<br>Winners will be notified shortly!<br><br><a href='index.php' class='main2'>CLICK HERE TO ENTER ANOTHER CONTEST!</a>";

mysql_close();
}

Any advice will help! Thanks!

[dannys]

You can get you DB to do all of the hardwork for you by defining a unique key made up of the fields you want to check - in this case these are the form id and the email address.

You can do this by doing

ALTER TABLE DATA ADD UNIQUE mykey (formID,emailAddress);

Or by setting it up in whatever db admin tool you use (eg phpMyAdmin, MySQLFront etc) - just make sure both fields are part of the key.

[tomhath]

Hope this isn't a double post, the first attempt just went away...

What went wrong? Give us a clue. The only thing wrong I see is you probably need a "$" inside the 'listID'

$query = "SELECT * FROM Data WHERE email='$email' AND listID='listID'";

[brianb]

Hey guys!

Look likes it IS working now....I saw that I did forget the missing $ before the listID statement!

Thanks for the help!

Can you maybe help me with one more thing???

In my forms I have a RADIO BUTTON signifying a YES or a NO. Yes is set to Y, and NO is set to N.....but that part of the form isn't being passed into my DB. It's just prints 0's.

Any idea what I'm doing wrong?

Thanks again.

[devarticles]

could you post the radio code?

[Radio]

It sounds as though it were a problem with the field specification.