Jump to content

Archived

This topic is now archived and is closed to further replies.

bartyl

Newsletter Signup Script Small Problem

Recommended Posts

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

Share this post


Link to post
Share on other sites
Well, for one thing, the correct syntax for SQL INSERT is:

INSERT INTO table_name VALUES (value1, value2,....)
not
INSERT INTO table_name SET column = value, column = value, ....

I don't know much about WordPress, so I'll leave it at that.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.