Problem sending automated email

[jackiw]

Hello,

How can I send a HTML email (which I know) with a link that tracks if they visited the website? This is what I'm doing:

$ver = mysql_query("SELECT * FROM mailinglist ORDER by email ASC");

$message = "My message goes in here...";

while($found = mysql_fetch_array($ver)) {

  $message .= "<a href=\"$link_url?email=$send_to\" target=_blank>$desc</a>";

  mail($found['email'], $SUBJECT, $message, $header);

}

I'm able to send the e-mail with the link working, but the link appears as many times I have emails in the database... I'm just not finding the correct place to put the 2nd $message line

[xblue]

well, you are appending all the time, so the first email would be sent with one link, the second with that one plus the new one and so on. maybe it works out this way (though I don't see where $send_to comes from)?

while($found = mysql_fetch_array($ver)) {
  $link = "<a href=\"$link_url?email=$send_to\" target=_blank>$desc</a>";
  mail($found['email'], $SUBJECT, $message.$link, $header);
}

[jackiw]

Thanks xblue, now it's working...

The $send_to is the same as $found['email'], just forgot to change when I was testing...

🙂