PHP - Sending Mail To All Email Addresses In Mysql Database

From our website we are connecting to GMAIL to send our emails through SMTP. For some reason it is not sending the emails to the CC or BCC email address event though GMAIL shows it was included in the email. Am I missing something in the below code?

Code: [Select]
$currentTime = time();

$emailTo = "redbrad0@domain.com";
$emailCC = "brad@domain.com";
$emailBCC = "events@domain.com";
$emailSubject = "TEST Email at (" . $currentTime . ")";
$emailBody = "This is the body of the email";

$headers = array();
if (!empty($emailTo))
$headers['TO'] = $emailTo;
if (!empty($emailCC))
$headers['CC'] = $emailCC;
if (!empty($emailBCC))
$headers['BCC'] = $emailBCC;
if (!empty($emailSubject))
$headers['Subject'] = $emailSubject;
$headers['From'] = "events@domain.com";

$mime = new Mail_mime("\n");
$mime->setTXTBody($emailBody);
$body = $mime->get();
$headers = $mime->headers($headers);

$mail = Mail::factory('smtp',
   array ('host' => 'ssl://smtp.gmail.com',
     'auth' => true,
     'port' => 465,
     'username' => 'events@domain.com',
     'password' => 'thepasswordhere'));

try {
  $result = $mail->send($emailTo, $headers, $emailBody);
} catch (TixException $ex) {     
  echo "<font color=red>Error:" . $ex->getCode() . "</font><br>";
}

echo "Emailed at (" . $currentTime . ")<br>";
die;

Everything about the email is sending except the message text does anyone know what the issue could be?

here is the block of code that sends the email
Thanks in advance
Code: [Select]
$image = "http://www.visualrealityink.com/dev/clients/arzan/snell_form/images/email.png";
echo "got to process form";
$target_path = "upload/";                   
$path = $target_path = $target_path . basename( $_FILES['file']['name']);                 
$boundary = '-----=' . md5( uniqid ( rand() ) );

$message .= "Content-Type: application/msword; name=\"my attachment\"\n";
$message .= "Content-Transfer-Encoding: base64\n";
$message .= "Content-Disposition: attachment; filename=\"$path\"\n\n";


echo $path;
$fp = fopen($path, 'r');
do //we loop until there is no data left
{
$data = fread($fp, 8192);
if (strlen($data) == 0) break;
$content .= $data;
  } while (true);
$content_encode = chunk_split(base64_encode($content));
$message .= $content_encode . "\n";
$message .= "--" . $boundary . "\n";
$message .= $image . "<br />" . $_POST['name'] . "submitted a resume on our website. Please review the applications and contact the candidate if their resume is a fit for any open opportunities with the company. <br><br> Thank you. <br><br> SEI Team";
$headers  = "From: \"Me\"<me@example.com>\n";
$headers .= "MIME-Version: 1.0\n";
$headers .= "Content-Type: multipart/mixed; boundary=\"$boundary\"";
mail('george@visualrealityink.com', 'Email with attachment from PHP', $headers, $message);

Hi, I got this script which I would like to send a message to all email addresses in the database or send to approved members only. Once I got the first part of this script working I can get the rest to work when sending to approved members.

Here is the form which passes the message to the script.

Code: [Select]
<?php 

include_once("data/server.php");

$all = 'unchecked';
$approved = 'unchecked';


if (isset($_POST['Submit1'])) {

$selected_radio = $_POST['Mailto'];

if ($selected_radio == 'all') {
$all = 'checked';

}
else if ($selected_radio == 'approved') {
$approved = 'checked';
}
}

?>

<div id="pageNav">
    <div id="sectionLinks"> <a href="admin.php?cmd=database&username=admin">Database</a> <a href="admin.php?cmd=uploads&username=admin">Uploads</a> <a href="admin.php?cmd=editTemplate&username=admin">Templates </a> <a href="admin.php?cmd=email&username=admin">Email</a> <a href="admin.php?cmd=messaging&username=admin">Messaging</a> <a href="admin.php?cmd=protected&username=admin">Protected Directory</a> <a href="admin.php?cmd=filesanddir&username=admin">Files and Directories</a> <a href="admin.php?cmd=usertracking&username=admin">User Tracking</a> <a href="admin.php?cmd=advanced&username=admin">Advanced</a> <a href="admin.php?cmd=uploads&username=admin">Uploads</a> <a href="admin.php?cmd=subscriptions&username=admin">Subscriptions</a> <a href="admin.php?cmd=applications&username=admin">Applications</a> <a href="admin.php?cmd=searchForms&username=admin">Search Form Builder</a> <a href="admin.php?cmd=categories&username=admin">Categories</a> <a href="admin.php?cmd=phpBB&username=admin">phpBB</a> <a href="admin.php?cmd=mySQL&username=admin">MySQL</a></div>
  </div>
  <div id="content">
   
    <div class="page">


<form action=templates/admin/msgtest.php method=POST>
<table>
<tr>
<td>Your Message:</td>
<tr><td>&nbsp;</td><td>&nbsp;</td></tr>
<tr><td><TEXTAREA NAME="message" COLS=40 ROWS=6></TEXTAREA></td></tr>
</table>
<table>
<tr>
<td><input type = 'Radio' Name ='Mailto' value= 'yes'
<?PHP print $all; ?>
</td>
<td>Send Message to all members</td>
</tr>
<tr>
<td><input type = 'Radio' Name ='Mailto' value= 'yes'
<?PHP print $approved; ?>
</td>
<td>Send Message to Approved members only</td>
</tr>
<tr><td colspan=2><input type=submit name=submit value=Submit></td></tr>
</table>
</form>



</table>
    </div>
   
  </div> 
</div>



And here is the code I have got so far but it doesnt work

Code: [Select]
<?php

include_once("../../data/server.php");
include("../../data/mysql.php");

if (isset($_POST['Submit1'])) {

$selected_radio = $_POST['Mailto'];

if ($selected_radio == 'all') {

$mysqlPassword = (base64_decode($mysqlpword));

$con = mysql_connect("$localhost", "$mysqlusername", "$mysqlPassword") or die(mysql_error());
mysql_select_db("$dbname", $con) or die(mysql_error());

 $q2 = "select * from games_newsletter ";
$result = mysql_query("SELECT email FROM profiles");   
 
while ($email = mysql_fetch_assoc($result)) {

$to = $email;
$subject = "Test Message";
$body = "This is a test message";
 $headers = "From: payments@tropicsbay.co.uk\r\n" .
     "X-Mailer: php";
 if (mail($to, $subject, $body, $headers)) {
   
// Redirect back to manage page
header("Location: admin.php?cmd=messaging");


} else {

echo "Approval Message Failed";

}
}
mysql_close($con);
}
}

?>
As always, any help is much appreciated

Paul

I'm setting up a newsletter thing for my website.

I have a newsletter table in MySQL:
Quote

+----------------+------+--------+
| email          | mens | womens |
+----------------+------+--------+
| test2@test.com |    1 |      1 |
| test1@test.com |    1 |      0 |
+----------------+------+--------+


I am using a HTML form and this PHP code I learn't from the manual, which sends out e-mail's.
PHP:
if ($_POST['newsletter'] == 'Mens') {
   $to = '';
   $subject = $_POST['subject'];
   $body = $_POST['body'];
   $header = 'From: Me Someone <me@someone.com>';
   mail($to, $subject, $body, $header);
}

What I want to do with the above code is send out an e-mail to all the e-mails in my MySQL database that are tagged '1' under mens.

How would I go about doing this? I'm guessing I will have to use a MySQL query in the $to = ''; that goes something like this:
$to = '$query (select from `newsletters` where `email` = 1');
?

Okay, below is my mailer for a contact form i created. On one site it works fine. I even have it sending to several addresses from the othersite. However this site it doesnt want to work. PHP5 and mail() function is active.


<?php 
$Name = Trim(stripslashes($_POST['fullname'])); 
$EmailFrom = Trim(stripslashes($_POST['email'])); 
$EmailTo = "james@jd-creations.co.uk";
$Subject = Trim(stripslashes($_POST['subject'])); 
$answer = Trim(stripslashes($_POST['answer'])); 
$Comments = Trim(stripslashes($_POST['message'])); 
$Subject = "The Reason - Contact Us";

// validation
$validationOK=true;
if (Trim($EmailFrom)=="") $validationOK=false;
if (Trim($answer)!=="20") $validationOK=false;
if (Trim($Name)=="")    $validationOK=false;
if (Trim($Comments)=="")  $validationOK=false;
if (Trim($Subject)=="")   $validationOK=false;
if (!$validationOK) {
  print "<meta http-equiv=\"refresh\" content=\"0;URL=../contact/error2.php\">";
  exit;
}

// prepare email body text
$Body = "";
$Body .= "Name: ";
$Body .= $Name;
$Body .= "\n";
$Body .= "Email: ";
$Body .= $EmailFrom;
$Body .= "\n";
$Body .= "Comments: ";
$Body .= $Comments;
$Body .= "\n";

// send email 
$success = mail($EmailTo, $Subject, $Body, "From: <$EmailFrom>");

// redirect to success page 
if ($success){
  print "<meta http-equiv=\"refresh\" content=\"0;URL=../contact/sent.php\">";
}
else{
  print "<meta http-equiv=\"refresh\" content=\"0;URL=../contact/error.php\">";
}
?>


now i know it is wroking because it takes me to the sent.php page. not error.php

i think it worked once. now not at all.

Hi Everyone,

I am trying to send email with the mail() function as per instructions at: http://php.net/manual/en/function.mail.php without success. The mail sends but when it arrives it doesn't render properly, I see all of the html tags with the data that's sent. My code is below:

Code: [Select]
<?php

function processFormData($array, $form)
{
    $errors = NULL;
    $message = NULL;
    $headers  = 'MIME-Version: 1.0' . "\r\n";
    $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
    $headers = "From: <chuck@deneb-consulting.com>" . "\r\n";
    $headers .="Cc: <tinwakr@bell.net>" . "\r\n";
    $headers .= "Reply-to: <chuck@deneb-consulting.com>" . "\r\n";
    $headers .= "X-Mailer: PHP/" .phpversion() . "\r\n";

    foreach($array as $key => $value)
    {
        //if any of the form values are empty catch them and add to error array
        if(empty($value) && $key != 'submit')
        {
            //build error list
            $errors .= '"' . str_replace('_', ' ', $key) . '" is a required field!<br />';
        }
        else if(!empty($value) && $key != 'submit')
        {
            //capture values and insert them into a session variable
            $_SESSION[$key] = $value;
        }
    }
    
    if(empty($errors))
    {
        $message = '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">' . "\r\n";
        $message .= '<html><head><title>' . $form .'</title></head>'
                . "\r\n" . '<body><table border="1">' . "\r\n";
        foreach($array as $key => $value)
        {
            //regular expression check for phone number
            if(str_replace('_', ' ', $key) == 'Phone Number' && !preg_match("/^([1]-)?[0-9]{3}-[0-9]{3}-[0-9]{4}$/i", $value))
            {
                return 'Please enter a valid phone number!';
            }
            //regular expression check for email
            if(str_replace('_', ' ', $key) == 'Email Address' && !preg_match("/^[A-Z0-9._%-]+@[A-Z0-9][A-Z0-9.-]{0,61}[A-Z0-9]\.[A-Z]{2,6}$/i", $value))
            {
                return 'Please enter a valid email address!';
            }
            if($key != 'submit')
            {
                $message .= '<tr><td>' . $key . '</td><td>' . $value . '</td></tr>' . "\r\n";
            }
        }
        $message .= '</table></body></html>' . "\r\n";
        mail("chuck@deneb-consulting.com", $form, str_replace("_", " ", $message), $headers);
        return 'Thank you, someone will contact you shortly.';
    }
    else
    {
        return $errors;
    }
}
?>

Thanks in advance for all replies,
Chuck

I have a notification system that notifies users of new comments, inside the email I have images, some of the logo, some of different people, everything shows up fine on my computer (yahoo email), however in the iPhones email application no images show up, there are just the blue squares with the question marks in them. I'm not sure what I'm missing.


Code: [Select]
$from = "Kithell <notifications@kithell.com>";
$headers = "From:" . $from ."\r\n";
$headers .= 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";


$subject = name($from_id, 'fl').$action;

$message = '<html><body>
<style>@charset "utf-8";
/* CSS Document */


.e-container {
background-color: #FFF;position: relative;width: 90%;min-height:1px;margin-right: auto;margin-left: auto;
}
.e-container .e-m-header {
padding: 2px;
background-image: url(http://www.kithell.com/assets/tall-grey-header.png);
background-repeat: repeat-x;
border: 1px solid #CCC;
background-position: bottom;
display: block;
text-align: center;
}
.e-container p {
font-family: Arial, Helvetica, sans-serif;
font-size: 12px;
font-weight: normal;
color: #666;
vertical-align: text-top;
display: inline-block;
}
.e-container .e-usr-photo {
display: inline-block;
margin: 10px;
float: left;
background-color: #F4F4F4;
}
.e-container p a {
font-weight: bold;
color: #3F60A3;
text-decoration: underline;
padding: 0px;
float: left;
margin-top: 0px;
margin-right: 5px;
margin-bottom: 0px;
margin-left: 0px;
}
.e-container .e-quotes {
font-size: 20px;
font-weight: bold;
color: #999;
font-family: Tahoma, Geneva, sans-serif;
display: block;
padding: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
margin-left: 75px;
margin-top:10px;

}
.e-container .e-message {
font-size: 13px;
color: #333;
padding: 0px;
margin-top: 0px;
margin-right: 10px;
margin-bottom: 0px;
margin-left: 10px;
clear: none;
display: inline;
}</style>
<div class="e-container"><div class="e-m-header"><img src="http://www.kithell.com/assets/kithell-logo.png" /></div><img class="e-usr-photo" src="http://www.kithell.com/'.photo($from_id, 55).'" /><br /><p><a target="_blank" href="http://www.kithell.com/#/profile&id='.$from_id.'">'.name($from_id, "fl").' </a> '.$action.'<div class="e-quotes">"<p class="e-message">'.nl2br(htmlentities(stripslashes($message))).'</p>"</div></p></div></body></html>';

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

I have an HTML form that I have a "select"  drop-down menu that is selecting the name of the person you should send to. The names are being pulled from the Database, and here is what that code for the drop-down in the form looks like:
<?php  
echo '<select name= "First_Name" , "Last_Name">'; 
while( $array = mysql_fetch_assoc($result) ) { 
    $text_for_select = $array["First_Name"] . " " . $array["Last_Name"]. " " . $array["District"]; 
$value_for_select = $array["First_Name"] . " " . $array["Last_Name"] . "_" . $array["id"]; 
echo "<option></option>\n"; 
echo "<option value=\"$value_for_select\">$text_for_select</option>\n";  
} 
echo '</select>';?>

This works perfectly. However, what I want it to do is send the form to the email address of the person that is selected in the drop-down. The email address' are already entered in each record of the database in a field called "Email". I am using the $value_for_select variable to pull the id of the record, but I am unsure how to then tell the form to send to the email address of that record? Anybody know a way that this can be done?

Here is the code of the for that should be sent:
 <?php  
    if($_POST){ 
    $to = $email; 
    $subject = "WHAT SHOULD THIS BE";     
    $message  =  "Date: $date\n\r". 
                 "Dear $First_Name, $Last_Name,\n\r". 
                 "Blah Blah BLah.Blah Blah BLah.Blah Blah BLah.Blah Blah BLah.Blah Blah BLah.Blah Blah BLah.Blah Blah BLah.Blah Blah BLah.Blah Blah BLah.Blah Blah BLah.Blah Blah BLah.Blah Blah BLah..\n\r". 
                 
                "Sincerely,\n". 
                "$name \n". 
                "$street \n". 
                "$city, $zip \n". 
                "$email \\n". 
    $headers = "From: $email"; 
    mail($to, $subject, $message, $headers); 
    // SUCCESS! 
    echo '<p class="notice">'. 
        'Thank you for your submission.  '. 
          '</p>'; 
    // clear out the variables for good-housekeeping 
    unset($date,$legislator,$bill,$name,$street,$city,$zip,$email); 
    $_POST = array(); 
} 
?>


Please help!
 

Hi all,

I have made some code based on following online youtube video for making a HTML form send to mySQL database via PHP: https://youtu.be/qm4Eih_2p-M

The form I am making is hopefully going to help in the Hospital at which I work to speed patient referrals, so I am very keen on making it work.

I have made the HTML form and the database, which I do not think are the problem.

When I click 'Submit' on my HTML form, then my php file comes up with all the code written, rather than the message: "New referral sent succesfully".

Additionally, when I check the database via 'MyPHPAdmin' there is no data added to the database I have made.

I have been using Sublime and have spotted some mistakes here and there, but is there something glaringly obvious that I am doing wrong in my code that is stopping my form being sent to the database?

Thank you,
Saman

<?php

$patientname = | $_POST['patientname'];
$hospitalnumber = | $_POST['hospitalnumber'];
$DoB = | $_POST['DoB'];
$specialty = | $_POST['specialty'];
$otherspecialty = | $_POST['otherspecialty'];
$admissiondate = | $_POST['admissiondate'];
$referring = | $_POST['referring'];
$bleep = | $_POST['bleep'];
$Admission = | $_POST['Admission'];
$Illness = | $_POST['Illness'];
$Awareness = | $_POST['Awareness'];
$question = | $_POST['question'];
$history = | $_POST['history'];
$medications = | $_POST['medications'];
$examination = | $_POST['examination'];
$results = | $_POST['results'];
$diagnosis = | $_POST['diagnosis'];
$investigations = | $_POST['investigations'];

	$host = "localhost"
	$dbUsername = "root";
	$dbPassword = "xyzabc";
	$dbname = "GreenCard";

	$conn = new mysqli($host, $dbUsername, $dbPassword, $dbname);

	if (mysqli_connect_error()) {
		die('Connect Error('. mysqli_connect_errno().')'. mysqli_connect_error());
	
	} else {
	$INSERT = "INSERT Into Greencard (patientname, hospitalnumber, DoB, specialty, otherspecialty, admissiondate, referring, bleep, Admission, Illness, Awareness, question, history, medications, examination, results, diagnosis, investigations) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";

	//Prepare statement
	$stmt = $conn->prepare($INSERT);
	$stmt->bind_param("sisissssssssssssss", $patientname, $hospitalnumber, $DoB, $specialty, $otherspecialty, $admissiondate, $referring, $bleep, $Admission, $Illness, $Awareness, $question, $history, $medications, $examination, $results, $diagnosis, $investigations);
	$stmt->execute();
	echo "New referral sent successfully";
	}
	$stmt->close();
	$conn->close();

} else {
	echo "Make sure fields are completed";
	die();
}

?>

 

Hi Everyone!  Thanks in advance for taking the time to review my post.  I am pretty new to PHP so please excuse my ignorance.

I am working a project for myself.  I want to be able to send out newsletters to my customers and sponsors.    I have written the code and here it is:

<?php
$subject = $_POST['subject'];
$message = $_POST['message'];
$email = "bubba@bubba.com";
$headers = "From: $email";
$email_list = file("elist.txt");
$total_emails = count($email_list);
for ($counter=0; $counter<$total_emails; $counter++) {
   $email_list[$counter] = trim($email_list[$counter]);
   }
$to = implode(",",$email_list);


if ( mail($to,$subject,$message,$headers) ) {
   echo "The email has been sent!";
   } else {
   echo "The email has failed!";
   }
?>

-----------------------------------------------------------------------------

In my elist.txt file - I have two fields.   Name and email.

Bubba|bubba@bubba.com
Oohay|oohay@yahoo.com

If i leave the names out of this file, the email script works great!

I want to leave the names in there and reference them in my email that I am sending out to be more personal. 

Can this be done and can you help?

Thanks!
Mike

Hi there,

I am using this code to send the users email address to the database. That works fine, but i keep getting blank info added to the database. Does anyone know how i can stop this?

<?php
$con = mysql_connect("*","*","*");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("ogs_mailinglist1", $con);

$sql="INSERT INTO mailinglist (email)
VALUES
('$_POST[rec_email]')";

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }

mysql_close($con);
?>



Thanks,

I want to send confirmation email to 2 different email boxes.
this is the code sending to one box:

{
$this->load->library('email');
//$config['mailtype'] = 'html';
//$this->email->initialize($config);

$this->email->from('no-reply@mymail.com 'Site team');
$this->email->to($em);

$this->email->subject('Welcome');
$msg = 'You have registered';

$this->email->message($msg);

$this->email->send();
}
thanks
and what should be the code sending same email to one more email box (example: mymail@gmail. com)

I am trying to send an e-mail message from a form, to each person in a MySQL database. In some cases, but not all, there are multiple e-mail address in the recordset. Each one should receive the same message addressed to them by name (FirstName and LastName) and e-mail address.  I have tried "CONCAT_WS(' ', emailtest.Pri_EmailAddress, emailtest.Sec_EmailAddress, emailtest.Tri_EmailAddress) AS EmailTo" but it seems the relay account is rejecting the message if more than one address is in the EmailTo result.
Any ideas or scripts that can do this would be appreciated.
Thank you in advance for your help.

Hello to all out there!
this is my first post,so my question may sound a bit simple. :]
I am studying PHP and MySQL and I tried to make a mailing form based on a mysql database.

My problem occured when I tried to use the PEAR mail object.

Here is my code:

// THE INCLUDED FILES
require_once ("attach_file.php"   );
require_once ("Mail.php"        );
require_once ("Mail\mime.php"   );

//THE VARIABLES TAKEN FROM THE HTML FORM OR JUST CREATED FOR THE CONSTRUCTION OF THE EMAIL
$my_email      = "something@gmail.com";
$email_subject = mysql_real_escape_string(trim( $_POST['email_subject']),$server_connect );
$email_body    = mysql_real_escape_string(trim( $_POST['email_body']   ),$server_connect );


$attached_file = $destination ;     // the $destination variable comes from the copy() function in attach_file.php
$username      = "the_username@gmail.com";
$password      = "the_password";
$host          = "smtp.gmail.com";

$attach        = new Mail_mime();
$attach -> addAttachment($attached_file);
$email_body    = $attach->get();

$extraheaders = array('from'=>$my_email,'to'=>$email_etaireias,'subject'=>$email_subject,'Bcc'=>$email_etaireias);
$headers       = $attach -> $headers($extraheaders);   // HERE GIVES ME AN ERROR!!! -->Fatal error: Method name must be a string

$smtp_info     = array('host'=>$host,'auth'=>TRUE,'username'=>$username,'password'=>$password);
$smtp          = Mail::factory('smtp',$smtp_info);


//loop through every single line of the database until there are no more lines with data
//and store each line in 3 different variables that i can use
while ( $row = mysql_fetch_array($result) )
{ $onoma_etaireias = $row['onoma_etaireias'];
  $email_etaireias = $row['email_etaireias'];
  $website_etaireias = $row['website_etaireias'];   }

//construct the mail function .  The @ is supressing the errors created .remove it and they will be shown.
$mail = @$smtp->send($email_etaireias,$headers,$email_body);



As i searched here and there for a solution, i found that it has something to do with the way the mail-mime object creates the body of the email . I also tried to find a solution from the PEAR documentation.
do i create the headers someway wrong?????

Im having a little trouble with the script below.  I get my three sql values returned fine, without a problem.
The problem is that Im not sending any emails with it.

Wether this is a problem with my syntax, headers, code ??? i dont know.
Please go easy on my scripts, im a learning newbie.

<html><body>
<?php
mysql_connect("***","***","***"); 
mysql_select_db("***") or die("Unable to select database"); 

$code = $_GET['postcode'];
$message = $_GET['message'];
$shortcode = substr($code,0,2);
$subject = "subject here";
$result = mysql_query("SELECT email FROM treesurgeons WHERE postcode like '%" . $shortcode . "%' ORDER BY companyName LIMIT 3")
or die(mysql_error());  
echo "<h2>Business Names:</h2>";                     
while($row = mysql_fetch_assoc($result)) 
{$message .= "\r\n". $row['email'] ;}
{$value = $row['email'].',';}
rtrim($row, ',');
$i = 0;
{$i++; switch($i)
{case 0:$value1 = $row['email']; break;
 case 1:$value2 =$row['email']; break;
 case 2:$value3 =$row['email']; break; }}
$to = "$value1, $value2, $value3";
echo nl2br ($message); 
$headers = 'From: me@me.com' . "\r\n" .
    'Reply-To: me@me.com' . "\r\n" .
    'X-Mailer: PHP/' . phpversion();
mail( "$to", "$subject","$message", "$headers");
echo "<br>" . "Thank you for using our mail form.";
?></body></html>