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: [!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]<?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.</P>" ); 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>"); } } ?>[/quote] i think the problem is in the last section [!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]<?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>"); } } ?>[/quote] 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