I have a mailer list I am trying to write. I have people enter their email and zipcode. Then I have it where I can choose a zipcode and have it email everybody within that zipcode I have selected. here is my script:
<?php
// Read POST request params into global vars
$from = $POST['from'];
$subject = $POST['subject'];
$message = $POST['message'];
$zipcode = $POST['zipcode'];
// Obtain file upload vars
$fileatt = $FILES['fileatt']['tmp_name'];
$fileatt_type = $FILES['fileatt']['type'];
$fileatt_name = $_FILES['fileatt']['name'];
$headers = "From: $from";
if (is_uploaded_file($fileatt)) {
// Read the file to be attached ('rb' = read binary)
$file = fopen($fileatt,'rb');
$data = fread($file,filesize($fileatt));
fclose($file);
// Generate a boundary string
$semi_rand = md5(time());
$mime_boundary = "==Multipart_Boundary_x{$semi_rand}x";
// Add the headers for a file attachment
$headers .= "\nMIME-Version: 1.0\n" .
"Content-Type: multipart/mixed;\n" .
" boundary=\"{$mime_boundary}\"";
// Add a multipart boundary above the plain message
$message = "This is a multi-part message in MIME format.\n\n" .
"--{$mime_boundary}\n" .
"Content-Type: text/plain; charset=\"iso-8859-1\"\n" .
"Content-Transfer-Encoding: 7bit\n\n" .
$message . "\n\n";
// Base64 encode the file data
$data = chunk_split(base64_encode($data));
// Add file attachment to the message
$message .= "--{$mime_boundary}\n" .
"Content-Type: {$fileatt_type};\n" .
" name=\"{$fileatt_name}\"\n" .
//"Content-Disposition: attachment;\n" .
//" filename=\"{$fileatt_name}\"\n" .
"Content-Transfer-Encoding: base64\n\n" .
$data . "\n\n" .
"--{$mime_boundary}--\n";
}
// Send the message
$db = mysql_connect(localhost,user,pass);
mysql_select_db(database,$db);
// the database has fields: id, email, zip
LINE 62 - $query = "SELECT * FROM mailer WHERE email ='' AND zipcode =''" mysql_real_escape_string($zipcode);
// above to MAKE SURE NO email goes to a blank adress, zipcode
$sql = mysql_query($query,$db) or die (mysql_error());
while ($row = mysql_fetch_array($sql)) {
if (!mail($row["email"],
$subject ,
$message,
$headers ))
{
echo "<FONT FACE=VERDANA, ARIAL SIZE=2>Error : Mail not sent to " . $row["email"] . "</FONT><BR>\n";
} else {
echo "<FONT FACE=VERDANA, ARIAL SIZE=2>Stamped, sealed and delivered to " . $row["email"] . "</FONT><BR>\n";
}
}
mysql_close($db);
?>
This is the error i keep recieveing:
Parse error: syntax error, unexpected T_STRING in /home/b5indust/public_html/mrtspizza.com/test/mail.php on line 62
I have highlighted line 62. I have rewritten and tried everything. I had a firend help me write this, and he is stuck as well. ANY HELP WOULD BE GREATLY APPRECIATED!
