Error in mailer script

[4BoredomDotCom]

This has an error way down at the $result=mysql_query($query) line.

Anyone knows whats up? Or could it be my login info? Is localhost bad?

[PHP]
<?php
/* grabs the POST variables and puts them into variables that we can use */
$email=$_POST['email'];
$city=$_POST['city'];
$state=$_POST['state'];

//---------VALIDATION-------->
if($email){//----> CHECK input
}
else{
$error.="Please, go back and fill out your e-mail address
\n";//----> ERROR if no input
}

if($city){//----> CHECK input
}
else{
$error.="Please, go back and fill out your city name
\n";//----> ERROR if no input
}
//-------->ERROR FREE??
if($error==""){
echo "Thank you for subscribing! A receipt of your submission will be e-mailed to you almost immediately.";
//----------------------------------
$mailContent="--------CONTACT--------\n"
."E-mail: ".$email."\n"
."City: ".$city."\n"
."State: ".$state."\n";
//----------------------------------
$toAddress="[e-mail]"; /* change this! */
$subject="Subscription"; /* change this! */
$recipientSubject="You are subscribed to the Whats Up In NH newsletter."; /* change this! */
$receiptMessage = "Thank you for joining WhatsUpInNH.com's Newsletter!\n\n\nHere is what you submitted to us:\n\n"
."--------CONTACT--------\n"
."E-mail: ".$email."\n"
."City: ".$city."\n"
."State: ".$state."\n";
//----------------------------------
mail($email, $subject, $receiptMessage,"From:$toAddress");
//----------------------------------
mail($toAddress,$recipientSubject,$mailContent,"From:$email");
//--->echo $mailContent;

//////////////////////////////////////// CONNECT TO MYSQL DB ////////////////////
// OPEN CONNECTION --->
$connection=mysql_connect("localhost","mylogin", "mypassword ") or die("Unable to connect!"); /* change this! */

mysql_select_db("database") or die("Unable to select database!"); /* change this! */

// EXECUTE QUERY --->
$query="INSERT INTO generalContact (
email,
city,
state;
VALUES(
'".$email."',
'".$city."',
'".$state."';
//////----->
$result=mysql_query($query) or die("Error in query:".mysql_error());
//if ($result)
//echo mysql_affected_rows()." row inserted into the database effectively.";

// CLOSE CONNECTION --->
mysql_close($connection);

///////////////////////////////////////////////////////////////////////////////////
}
else{

print "Sorry, but the form cannot be sent until the fields indicated are filled out completely -
\n";
print "$error
\n";
print "
\n";
print "
\n";
print "Please use your \"Back\" button to return to the form to correct the omissions. Thank you.
\n";
}

?> [/PHP]

[4BoredomDotCom]

anyone? nmn

[barnamos]

what does the mysql_error tell you is happening?

[PoA]

Wrong
[PHP]$query="INSERT INTO generalContact (
email,
city,
state;
VALUES(
'".$email."',
'".$city."',
'".$state."'; [/PHP]

Correct
[PHP]
$query="INSERT INTO generalContact (
email,
city,
state)
VALUES('$email', '$city', '$state')"; [/PHP]

Your corrected source code
[PHP]
/* grabs the POST variables and puts them into variables that we can use */
$email=$_POST['email'];
$city=$_POST['city'];
$state=$_POST['state'];

//---------VALIDATION-------->
if($email){//----> CHECK input
}
else{
$error.="Please, go back and fill out your e-mail address
\n";//----> ERROR if no input
}

if($city){//----> CHECK input
}
else{
$error.="Please, go back and fill out your city name
\n";//----> ERROR if no input
}
//-------->ERROR FREE??
if($error==""){
echo "Thank you for subscribing! A receipt of your submission will be e-mailed to you almost immediately.";
//----------------------------------
$mailContent="--------CONTACT--------\n"
."E-mail: ".$email."\n"
."City: ".$city."\n"
."State: ".$state."\n";
//----------------------------------
$toAddress="[e-mail]"; /* change this! */
$subject="Subscription"; /* change this! */
$recipientSubject="You are subscribed to the Whats Up In NH newsletter."; /* change this! */
$receiptMessage = "Thank you for joining WhatsUpInNH.com's Newsletter!\n\n\nHere is what you submitted to us:\n\n"
."--------CONTACT--------\n"
."E-mail: ".$email."\n"
."City: ".$city."\n"
."State: ".$state."\n";
//----------------------------------
mail($email, $subject, $receiptMessage,"From:$toAddress");
//----------------------------------
mail($toAddress,$recipientSubject,$mailContent,"From:$email");
//--->echo $mailContent;

//////////////////////////////////////// CONNECT TO MYSQL DB ////////////////////
// OPEN CONNECTION --->
$connection=mysql_connect("localhost","mylogin", "mypassword ") or die("Unable to connect!"); /* change this! */

mysql_select_db("database") or die("Unable to select database!"); /* change this! */

// EXECUTE QUERY --->
$query="INSERT INTO generalContact (
email,
city,
state)
VALUES('$email', '$city', '$state')";
//////----->
$result=mysql_query($query) or die("Error in query:".mysql_error());
//if ($result)
//echo mysql_affected_rows()." row inserted into the database effectively.";

// CLOSE CONNECTION --->
mysql_close($connection);

///////////////////////////////////////////////////////////////////////////////////
}
else{

print "Sorry, but the form cannot be sent until the fields indicated are filled out completely -
n";
print "$error
n";
print "
n";
print "
n";
print "Please use your "Back\" button to return to the form to correct the omissions. Thank you.
\n";
}

[/PHP]