email

[Anon]

I have a program that is to send an email to every person in my database. It works for the first person in the database but then returns an error -> something like cannot redeclare email function!! I pass the email function the username and email address every time i go through the loop!! Anyone any ideas ??

[shellyw]

Below is a little PHP script I use to send our newsletters, checking first in the database to see if member wants to receive it. My only problem is that I am on a virtual server and the messages come from "[e-mail]". I haven't figured out how to get it to use "From: [e-mail]" yet.

Regards, Shelly

<?
$db = mysql_connect("MYDBSERVER","MYLOGIN","MYPASS");
mysql_select_db("MYDB",$db);

$query = mysql_query("SELECT * FROM members ",$db);
while ($row = mysql_fetch_array($query)) {
$id=$row["id"];
$fname = $row["fname"];
$lname = $row["lname"];
$nname = $row["nname"];
$email = $row["email"];
$hcmail = $row["hcmail"];

if ($hcmail == "Y") {
$sendto = $email;

$subject = "Newsletter, March 2001";

$message = "Dear Member,

PLACE TEXT OF YOUR MESSAGE HERE... ";

mail($sendto, $subject, $message);
echo "ID: $id $fname $lname ($nname) $email - Done!\n";
}
else
{
$sendto = "[e-mail]";
$subject = "Member Update Message Problem";

$message = "Newsletter could not be sent to the following member:

            ID: $id Name: $fname $lname ($nname)
            Email: $email";
mail($sendto, $subject, $message);

echo "ID: $id $fname $lname ($nname)$email - Error!\n";
}
}
echo "Done!\n";
?>