01.<html>
02.<head>
03.<title>ThaiCreate.Com PHP Sending Email</title>
04.</head>
05.<body>
06.<?
07.$objConnect = mysql_connect("localhost","root","root") or die("Error Connect to Database");
08.$objDB = mysql_select_db("mydatabase");
09.$strSQL = "SELECT * FROM customer";
10.$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
11.while($objResult = mysql_fetch_array($objQuery))
12.{
13.
14. $strTo = $objResult["Email"];
15. $strSubject = "Test Send Email";
16. $strHeader = "Content-type: text/html; charset=windows-874\n";
17. $strHeader .= "From: Mr.Weerachai Nukitram<webmaster@thaicreate.com>\nReply-To: thaicreate@hotmail.com";
18. $strVar = "My Message";
19. $strMessage = "
20. <h1>My Message</h1><br>
21. <table width='285' border='1'>
22. <tr>
23. <td><div align='center'><strong>My Message </strong></div></td>
24. <td><div align='center'><font color='red'>My Message</font></div></td>
25. <td><div align='center'><font size='2'>My Message</font></div></td>
26. </tr>
27. <tr>
28. <td><div align='center'>My Message</div></td>
29. <td><div align='center'>My Message</div></td>
30. <td><div align='center'>My Message</div></td>
31. </tr>
32. <tr>
33. <td><div align='center'>".$strVar."</div></td>
34. <td><div align='center'>".$strVar."</div></td>
35. <td><div align='center'>".$strVar."</div></td>
36. </tr>
37. </table>";
38.
39. @mail($strTo,$strSubject,$strMessage,$strHeader);
40.}
41.?>
42.</body>
43.</html>
