I'm trying to send an email in html format. my code is as follows. I've tried using a content type before the body of the email, but it isn't configured correctly since it isn't working.
please help
Code:<?php $connection = mysql_connect("localhost", "", "") or die ("Couldn't connect to the server."); $db = mysql_select_db("", $connection) or die ("Couldn't select database."); $sql = "select * from Speedpay_Main where LoanAcctNo = '$acctNumber'"; $SQLresult = mysql_query($sql, $connection) or die("1"); while ($row = mysql_fetch_array($SQLresult)){ $firstName = $row["firstName"]; $lastName = $row["lastName"]; $email = $row["email"]; } $sql2 = "select * from Speedpay_loanInfo where transID = '$maxTransID'"; $SQLresult2 = mysql_query($sql2, $connection) or die("2"); while ($row = mysql_fetch_array($SQLresult2)){ $monthlyMrtg = $row["monthlyMrtg"]; $code = $row["code"]; $lstPmt = $row["lstPmt"]; $minPmt = $row["minPmt"]; $totalPmt = $row["totalPmt"]; $lstPmtAmt = $row["lstPmtAmt"]; $transID = $row["transID"]; $transaction = $row["transaction"]; $checkNum = $row["checkNum"]; $checkFeeNum = $row["checkFeeNum"]; } $mail_to = $email; $mail_from = "SammyD"; $mail_subject = "Your Speedpay confirmation email"; $mail_body = "Content-type: text/html; charset=us-ascii"; $mail_body .= "<html><head><title>Speedpay Confirmation email for ".$firstName." ".$lastName."</title></head>\n"; $mail_body .= "<body><table><tr><td>Name: </td><td>".$firstName." ".$lastName."</td></tr>"; $mail_body .= "<tr><td>Last Payment: </td><td>".$lstPmt ."</td></tr>\n"; $mail_body .= "<tr><td>Confirmation number: </td><td>".$transID ."</td></tr>\n"; $mail_body .= "<tr><td>Check number: </td><td>".$checkNum ."</td></tr>\n"; $mail_body .= "<tr><td>Check number for Fee: </td><td>".$checkFeeNum ."</td></tr>\n"; $mail_body .= "</table></body></html>\n"; if(mail($mail_to, $mail_subject, $mail_body)) echo "Thank you for using Speedpay. A confirmation email has been sent to your default email address of: ".$email; else echo "Failed!"; ?>
THANKS,
dlg
Bookmarks