I'm totally clueless on this one -- I'm getting 3 copies of every Email (in
plain text, not HTML as expected), from a single mail() line... Can anyone
tell me what might be causing the duplicates??
Thanx!
Wm
<?PHP
include('dbconn .php');
$query="SELECT
artistID,active ,email,firstnam e,lastname,city ,state,mentor from artists
WHERE artistID='$arti stID'";
$result=mysql_q uery($query) or die(mysql_error ("Could not execute
query."));
while($row = mysql_fetch_arr ay($result)) {
$email = $row['email'];
$notactive = $row['active'];
$firstname = $row['firstname'];
$lastname = $row['lastname'];
$city = $row['city'];
$state = $row['state'];
$mentor = $row['mentor'];
if ($mentor == "1") {
$class = "as a Mentor";
}
else {
$class = "as an Assistant";
}
if (($notactive == "0") AND ($ver == "1")) {
mysql_query("UP DATE artists SET active='1' WHERE artistID =
'$artistID' LIMIT 1");
echo "Your listing has been successfully activated -- welcome to
Makeup Mentors!<BR>
Please tell a friend about this resource!";
// generate Email
$headers = "From: domain.com <Webmaster@doma in.com>\n";
$headers .= "X-Sender: <Webmaster@doma in.com>\n";
$headers .= "X-Mailer: domain.com\n"; //mailer
$headers .= "X-MSMail-Priority: Normal\n";
$headers .= "X-Priority: 3\n"; //1 UrgentMessage, 3 Normal
$headers .= "Return-Path: <Webmaster@doma in.com>\n";
$headers .= "bcc: mary@herdomain. com";
$headers .= "Content-Type: text/html; charset=iso-8859-1\n";
$city = stripslashes($c ity);
$message = "
<p align=\"left\"> domain.com has just activated the following artist
$class:</p>
<p align=\"left\"> Name: $firstname $lastname<br>
Location: $city, $state</p>
<p> </p>
<p align=\"left\"> Webmaster<br>
<A HREF=\"http://www.domain.com\ ">www.domain.co m</A></p>";
$subject = "Makeup Mentors listing verification";
$to = "william@mydoma in.net";
mail($to, $subject, $message, $headers);
}
else if (($active > 0) AND ($ver == "1")) {
echo "Your listing is already activated.<BR>" ;
}
}
?>
plain text, not HTML as expected), from a single mail() line... Can anyone
tell me what might be causing the duplicates??
Thanx!
Wm
<?PHP
include('dbconn .php');
$query="SELECT
artistID,active ,email,firstnam e,lastname,city ,state,mentor from artists
WHERE artistID='$arti stID'";
$result=mysql_q uery($query) or die(mysql_error ("Could not execute
query."));
while($row = mysql_fetch_arr ay($result)) {
$email = $row['email'];
$notactive = $row['active'];
$firstname = $row['firstname'];
$lastname = $row['lastname'];
$city = $row['city'];
$state = $row['state'];
$mentor = $row['mentor'];
if ($mentor == "1") {
$class = "as a Mentor";
}
else {
$class = "as an Assistant";
}
if (($notactive == "0") AND ($ver == "1")) {
mysql_query("UP DATE artists SET active='1' WHERE artistID =
'$artistID' LIMIT 1");
echo "Your listing has been successfully activated -- welcome to
Makeup Mentors!<BR>
Please tell a friend about this resource!";
// generate Email
$headers = "From: domain.com <Webmaster@doma in.com>\n";
$headers .= "X-Sender: <Webmaster@doma in.com>\n";
$headers .= "X-Mailer: domain.com\n"; //mailer
$headers .= "X-MSMail-Priority: Normal\n";
$headers .= "X-Priority: 3\n"; //1 UrgentMessage, 3 Normal
$headers .= "Return-Path: <Webmaster@doma in.com>\n";
$headers .= "bcc: mary@herdomain. com";
$headers .= "Content-Type: text/html; charset=iso-8859-1\n";
$city = stripslashes($c ity);
$message = "
<p align=\"left\"> domain.com has just activated the following artist
$class:</p>
<p align=\"left\"> Name: $firstname $lastname<br>
Location: $city, $state</p>
<p> </p>
<p align=\"left\"> Webmaster<br>
<A HREF=\"http://www.domain.com\ ">www.domain.co m</A></p>";
$subject = "Makeup Mentors listing verification";
$to = "william@mydoma in.net";
mail($to, $subject, $message, $headers);
}
else if (($active > 0) AND ($ver == "1")) {
echo "Your listing is already activated.<BR>" ;
}
}
?>
Comment