PHP Array from SQL Database

[border9]

What im attempting to do is pull email address from a database already built, i need to be able to select the email address depending on the date they are given.

Then i need to be able to Implode the list of email address so i can send out multiple emails to multiple Clients at one time. This is what i have so far.


*************** ***Form Application**** ************

<select name="emailto" size="15" multiple id="emailto" style="color: #000000; font-size: 8pt; font-family: Verdana" tabindex="">

<?php
$users_sql = "SELECT * FROM ******* WHERE site_tag = '*****' AND date_received BETWEEN '" . $_POST["startDate"] . "' AND '" . $_POST["endDate"] . "'";
$users_result = @mysql_query($u sers_sql);
while($users = @mysql_fetch_ar ray($users_resu lt))

{
echo "<option";

echo">" . $users["email"] ;
echo",</option>\n";

}

?>
</select>

*************** ***********
*************** ***********php code*********** **********

if($_POST['email_now'])
{

$to = $_POST['emailto'];
$from = "************** *";
$subject = "************** *****";
$headers .= ''************* **".$eol;
$headers .= '************** '.$eol;
$headers .= 'Return-Path: '.$eol; // these two to set reply address
$headers .= "Message-ID: <".$subject.">" .$eol;
//$headers .= "Message-ID: <".$now." TheSystem@".$_S ERVER['SERVER_NAME'].">".$eol;
$headers .= "X-Mailer: PHP v".phpversion() .$eol; // These two to help avoid spam-filters
# Boundry for marking the split & Multitype Headers
$mime_boundary= md5(time());
$headers .= 'MIME-Version: 1.0'.$eol;
$headers .= 'Content-Type: text/html; charset=iso-8859-1'.$eol;
$body= $_POST['edited'];
//EOF;

$success = mail($to, $subject, $body, $headers);

if ($success)
{
$msg="";
mass_email($msg );


}
else
{
$msg=".";
mass_email($msg );

}
}

But what i need it to do is when i select or whoever i select from that form and click Email, it emails all of them. and i cant figure out for the life of me what im doing wrong.

[ak1dnar]

Could you please tell us,what is NOT working in this script?
Please USE CODE tags in future.

[border9]

Its not allowing me to send to the email address the Form brings up. Right now i have it pulling about 15 email addresses from the Database and its not sending to them only one.

[ak1dnar]

Print your emails in the list menu like this: set the name attribute in this way emailto[]

<select name="emailto[]" multiple="MULTIPLE" id="emailto[]">
  <option value="[e-mail]">[e-mail]</option>
  <option value="[e-mail]">[e-mail]</option>
  <option value="[e-mail]">[e-mail]</option>
</select>

On server page

<?php
$toArray = $_POST['emailto'];
$explodedString = implode(",",$toArray);
echo $explodedString;
?>

Outputs:

[e-mail],[e-mail],[e-mail]

Pass the $explodedString to the mail() function.

[border9]

Print your emails in the list menu like this: set the name attribute in this way emailto[]

<select name="emailto[]" multiple="MULTIPLE" id="emailto[]">
  <option value="[e-mail]">[e-mail]</option>
  <option value="[e-mail]">[e-mail]</option>
  <option value="[e-mail]">[e-mail]</option>
</select>

On server page

<?php
$toArray = $_POST['emailto'];
$explodedString = implode(",",$toArray);
echo $explodedString;
?>

Outputs:

[e-mail],[e-mail],[e-mail]

Pass the $explodedString to the mail() function.

I see where your going with that, But i need to pull the emails from the database, they arent emails i put in myself. That Form is built off email address from the mySQL Database. How do i create the array from the emails in the database?

[border9]

Anyone have any idea what im trying to attempt here or what i have to do to make it work?

If you can help please by all means i would greatly appricate it. Thanks

[ak1dnar]

Oh you want to build the List menu right?
Sorry I don't have a Email Database with me, So I'm using one of my existing database.

<?php 
@mysql_connect("localhost","root","dba")or die(mysql_error());
@mysql_select_db("my_store")or die(mysql_error());
$result = mysql_query("SELECT p_name from products");
while($row=mysql_fetch_array($result)){
$options .= '<option value="'.$row['p_name'].'">'.$row['p_name'].'</option>';
}
?>
<html>
<body>
<form action="index.php" method="post">
<select name="emailto[]" multiple="MULTIPLE" id="emailto[]">
<?php echo $options ?>
</select>
<input type="submit" name="Submit" value="Submit" />
</form>
</body>
</html>
 

[border9]

Ok, so that builds the menu, how do i take whats in that menu and email all of the clients that are brought up in that menu?

I need to be able to Click iether 1 or 20 of those items in that menu and be able to email the. Any ideas?

[border9]

[PHP]
<?php
if($_POST['email_now'])
{

$to = $_POST['emailto'];
$from = "";
$subject = "";
$headers .= "".$eol;
$headers .= "".$eol;
$headers .= 'Return-Path: '.$eol; // these two to set reply address
$headers .= "Message-ID: <".$subject.">" .$eol;
//$headers .= "Message-ID: <".$now." TheSystem@".$_S ERVER['SERVER_NAME'].">".$eol;
$headers .= "X-Mailer: PHP v".phpversion() .$eol; // These two to help avoid spam-filters
# Boundry for marking the split & Multitype Headers
$mime_boundary= md5(time());
$headers .= 'MIME-Version: 1.0'.$eol;
$headers .= 'Content-Type: text/html; charset=iso-8859-1'.$eol;
$body= $_POST['edited'];
//EOF;

$success = mail($to, $subject, $body, $headers);

if ($success)
{
$msg="";
mass_email($msg );


}
else
{
$msg=".";
mass_email($msg );

}
}
?>
[/PHP]

I need this code to be able to read iether 1 or multiple selections for the List that is created from the database. What i need it to do is Send out an Email to any Selected Items from that list.

[border9]

Can anyone see what im trying to acomplish here?