bartyl Posted March 20, 2006 Share Posted March 20, 2006 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 hereif (! @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><?phpif ("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--]<?phpif ("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 workthanks in advance Quote Link to comment Share on other sites More sharing options...
dcro2 Posted March 21, 2006 Share Posted March 21, 2006 Well, for one thing, the correct syntax for SQL INSERT is:INSERT INTO table_name VALUES (value1, value2,....)notINSERT INTO table_name SET column = value, column = value, ....I don't know much about WordPress, so I'll leave it at that. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.