Newsletter Signup Script Small Problem

[bartyl]

i am trying to create a small script for my blog, www.bartysblog.be where users can input their email address to signup for a newsletter or updates. the email address is stored in a database. the script byitself runs fine and stores the email in the database but when i copy to code into wordpress it doesnt work.
i think i know why but dont know how to fix it.
heres the code so far:

<?php

/**


@version $Id$
@copyright 2006
*/
$dbcnx = @mysql_connect("localhost", "bartyl_bartyl", "rudeboy");
if (!$dbcnx) {
echo( "<P>Unable to connect to the " .
"database server at this time." );
exit();
}
//Select Database here
if (! @mysql_select_db("bartyl_test") ) {
echo( "<P>Unable to locate the test " .
"database at this time.</P>" );
exit();
}
$result = mysql_query("SELECT Email FROM Users");
if (!$result) {
echo("<P>Error performing query: " .
mysql_error() . "</P>");
exit();
}

?>
<FORM ACTION="<?php echo $_SERVER['PHP_SELF']; ?>" METHOD=POST>
<P>Type your Email here:<BR>
<TEXTAREA NAME="email" style="width:200px" height:15px WRAP></TEXTAREA><BR>
<INPUT TYPE=SUBMIT NAME="submitjoke" VALUE="SUBMIT">
</FORM>

<?php
if ("SUBMIT" == $submitjoke) {
$sql = "INSERT INTO Users SET " .
"Email='$email', " .
"Date=CURDATE()";
if (mysql_query($sql)) {
echo("<P>Your Email has been added.</P>");
} else {
echo("<P>Error adding submitted joke: " .
mysql_error() . "</P>");
}
}
?>

i think the problem is in the last section

<?php
if ("SUBMIT" == $submitjoke) {
$sql = "INSERT INTO Users SET " .
"Email='$email', " .
"Date=CURDATE()";
if (mysql_query($sql)) {
echo("<P>Your Email has been added.</P>");
} else {
echo("<P>Error adding submitted joke: " .
mysql_error() . "</P>");
}
}
?>

the script only runs when the text, Your Email has been added is shown and in wordpress the text isnt shown. i need to change it so that the text doesnt need 2 run for the rest of the script to work
thanks in advance

[bogu]

Well I think your problem is that Email field is a UNIQUE field and the error handler in your script is not that accurate.

Try something like this :

<?php
if ("SUBMIT" == $submitjoke) {
	$sql = "INSERT IGNORE INTO Users SET ";
	$sql.= "Email= '{$email}', ";
	$sql.= "Date=CURDATE()";
	mysql_query($sql) or die(mysql_error());
	if (mysql_affected_rows()) {
		echo "<P>Your Email has been added.</P>";
	} else {
		echo "<P>Error adding submitted joke. Probably your email address already exists in DB!</P>";
	}
}
?>