Originally posted by Ajayme
View Post
Mysql table "messagelist" with 2 fields
Code:
as id [email] => "demo@mailer.com" message=> "Hellow there how are you"
PHP Code:
<?php
$emails = array();
$select = mysql_query('SELECT `email` FROM `users`');
while ($sel = mysql_fetch_array($select)) {
$emails[] = $sel[0];
}
foreach ($emails as $email) {
$select = mysql_fetch_array(mysql_query('SELECT message FROM messagelist WHERE email="'.$email.'" '));
if(empty($select[0])){
// if is no message stored for email@
$selectmessage="Hellow there";
}
else{
// message from database for email@
$selectmessage=$select[0];
}
$subject = 'Subject...';
$message = $selectmessage ;
$header = 'MIME-Version: 1.0'.PHP_EOL;
$header .= 'Content-type: text/html; charset=utf-8'.PHP_EOL;
$header .= 'From: mailing@mail.com';
@mail($email, $subject, $message, $header);
echo 'Sent!';
}
?>

Leave a comment: