multiple question > mail formatting and retrieving mail list

[phpjaco]

hello. i want to do the following and was just wondering how this would work:

I want to sent an newsletter to all my newsletter subscribers, their email addressses are stored inside a mylsql db.

so would i do it like this:

while ($row = mysql_fetch_array($rs)) {
$to = $row['email'];
$re = "newsletter";
$msg = $content;
mail($to,$re,$msg);
}

would this work, so every time the record set increments it would sent out a email, have not tested it just want to make sure im on the right track.

also how do you get to use html in email, for example <b></b>, italics and images.

have always wondered about this since all my emails are pretty much just text, I use \n\n etc.
and how complicated is it to use images in emails?

[Roger_Ramjet]

You need to use MIME encoding to send html, see here for details http://uk2.php.net/manual/en/function.mail.php. Also, you can if you like put multiple recipients into the $to and just send the 1 email, all will get it.

[phpjaco]

hello

been reading up on MIME and have the following code, was just wondering how do I put the image in?

The following code basically does this, sets up a MIME type email and creates a multipart/mixed bounday, the first part adds the html text but the second part is suppose to add the image.

But the image does not get sent as an attachment / or inline (have tried both) why is that?
When you say content-type:image/gif;name:url/images/imagename.gif

does name refer to the url of the image too?

// set the header information
$headers = "MIME-Version: 1.0\r\n";
$headers .= "Content-type : multipart/mixed;boundary=DOMAIN-1886\r\n";

// first boundary starts here - normal text       

$headers .= "--DOMAIN-1886\r\n";
$headers .= "Content-Type:text/html\r\n";
$headers .= "Content-Transfer-Encoding:7bit\r\n";
$headers .= "$message\r\n";

// second boundary start here - image
$headers .= "--DOMAIN-1886\r\n";

$headers .= "Content-Type:image/gif;name='$image'\r\n";
$headers .= "Content-Transfer-Encoding:base64\r\n";
$headers .= "Content-Disposition:inline\r\n";

$headers .= "--DOMAIN-1886--\r\n";

mail($to,$re,"",$headers);