I'm trying to add a prayer E-mail list to my church's website and have
run into a brick wall as I was trying to add my own E-mail address to
the database where all that info is stored.
The command it's complaining about is as follows:
$sql = "select * from maillist where plmail='" . $plmail . "' and
where passcode='" . $passcode "'") or die("SELECT Error: " .
mysql_error() . " in Query: $sql";
For the record, this is the next-to-last line on here, which is
appearing indented in this box. This snippet of code is part of a
block that executes if someone is trying to remove their E-mail
address from the list.
I've included quite a few lines before this too and have only posted
the possible suspects and eliminated everything that works properly.
I've tried several things with this, and quite frankly, I'm stumped.
If anyone knows why this is happening, I'd really like to know. Thanx!
Fred
<begin code>
$passcode = rand(0,16777216);
if ($action) { // action=1 is to subscribe, action=0 is to delete
include("dblogin.php");
$select = mysql_select_db("wcc") or die("Sorry -- I cannot connect to
the database because " . mysql_error());
$insert = "insert into maillist (plname, plmail, passcode, active,
staff)
values ('$_POST[plname]','$_POST[plmail]','$_POST[passcode]',0,0)";
$rs = mysql_query($insert, $conn) or die("Sorry -- I cannot run the
query because " . mysql_error());
if(!mysql_error()) {
// No error
$tbody="Dear " . $name . ".\r\n\r\n";
$tbody.="To officially add yourself to the prayer list, please <a
href=\"http://www.westportchurch.com/confirm.php?plmail=\"; . $plmail .
\"&passcode=\" . $passcode . \"&action=1\>click here</a>.";
$headers="From: \"Your name\" <Your email>";
$subject="We're almost done with the verification process...";
mail($email, $subject, $tbody, $headers);
}
}
else {
include("dblogin.php");
$select = mysql_select_db("wcc") or die("Sorry -- I cannot connect to
the database because " . mysql_error());
<this is what it doesn't like>
$sql = "select * from maillist where plmail='" . $plmail . "' and
where passcode='" . $passcode "'") or die("SELECT Error: " .
mysql_error() . " in Query: $sql";
</this is what it doesn't like>
$rs = mysql_query($sql, $conn) or die("Sorry -- I cannot run the
query because " . mysql_error());
------------------------ Yahoo! Groups Sponsor --------------------~-->
AIDS in India: A "lurking bomb." Click and help stop AIDS now.
http://us.click.yahoo.com/9QUssC/lzNLAA/TtwFAA/HKFolB/TM
--------------------------------------------------------------------~->
Community email addresses:
Post message: [email protected]
Subscribe: [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
List owner: [EMAIL PROTECTED]
Shortcut URL to this page:
http://groups.yahoo.com/group/php-list
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php-list/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
