[woyrz]

Hi

I am trying to build a template in html to do my e-mail. Using the aministration pannel some could comme typing the the email content and hit send. The template is automaticly apply and send to all the pepoel in the database using the mail() fonction.

So far what i have is working perfecly but the email is sent in whatever format that not show the html as html content. So the use get all the html code!!! So enoying !!!

<?php
mysql_connect("localhost", "user","somme passe") or die (mysql_error());
mysql_select_db("mydatabase") or die(mysql_error());

$sql = mysql_query("SELECT * FROM `table` WHERE lang='fr'");
//$result = mysql_query($sql,$db) or die (mysql_error());
while ($mafonction = mysql_fetch_array($sql)) {
$email= $mafonction ['email'];

$msg = "<a href=\"http://wwww.mediaflexdesign.com/index.php?username=$email\">test</a>";
$recipient = "$email";
$subject = "Your chrimast card";
$mailheaders = "From: Media flex design site web <admin@mediaflexdesign.com>\n";
$mailheaders .= "Reply-To: <admin@mediaflexdesign.com>\n\n";

mail($recipient, $subject, $msg, $mailheaders);

}
?>

I need help !!!

please
Woyrz

[mdhall]

Try removong the // from your query....

//$result = mysql_query($sql,$db) or die (mysql_error());

to this

$result = mysql_query($sql,$db) or die (mysql_error());

"//" makes the line a comment, i believe, so it may be blocking the results from actually being processed.

[woyrz]

Originally Posted by mdhall

Try removong the // from your query....

//$result = mysql_query($sql,$db) or die (mysql_error());

to this

$result = mysql_query($sql,$db) or die (mysql_error());

"//" makes the line a comment, i believe, so it may be blocking the results from actually being processed.

it's not woriking. the e-mail is sent!! i have not prob with that is juste in the format. Is sendding the email in text format when it whoud send it in html format

Woyrz

[hyjacked]

mdhall, he is hardcoding data in below that.

An obvious question but I'll ask anyways. Does the email program support html?

[woyrz]

Originally Posted by hyjacked

mdhall, he is hardcoding data in below that.

An obvious question but I'll ask anyways. Does the email program support html?

yes i does

[hyjacked]

I couldn't come up with anything besides you are missing a setting that would tell it to send it as html email, but even that doesn't make sense. I would almost think it is more of a problem on the email client side then the server sending.

here is the php.net page for mail():
http://www.php.net/manual/en/ref.mail.php

edit:
Actually I just found this, took it from the above link about 3/4 of the down the page into the user submitted comments. Try merging this into your code.

PHP Code:

// html section 

 $Msg.="\n--".$IB."\n";

 $Msg.="Content-Type: text/html;\n\tcharset=\"iso-8859-1\"\n";

 $Msg.="Content-Transfer-Encoding: base64\n\n";

 // html goes here 

 $Msg.=chunk_split(base64_encode($Html))."\n\n"; 

[mdhall]

Ok, guess I misunderstood the problem he was having.

[whiteraider]

PHP Code:

/*basic mail settings */

$Msg="some HTML message";

$subject  = "some subject";

$headers  = "MIME-Version: 1.0;\n";

$headers .= "Content-type: text/html; charset=iso-8859-1;\n";



/* additional headers */

//$headers .= "To: webmaster <webmaster@somedomain.com>;\n";

$headers .= "From: Errors <errors@somedomain.com>;\n";

$headers .= "Cc: [email]admin@somedomain.com[/email];\n";

$headers .= "Bcc: [email]another.boss@somedomain.com[/email];\n";



/* and now mail it */

mail($to, $subject, $Msg, $headers); 

This is the code that I use to mail a html table from one of my sites

The $headers TO field is commented out because the server uses QMail which has a bug that sends a copy of the mail for any TO field, so 2 copies get sent not 1.

Also note that there is a ; (semi-colon) at the end of each header, this also is needed otherwise the message gets sent as text. - This had me stumped for a while as my test server didn't need them!