storing email addresses in a string...

[jas4]

Hi,

 

If i pull say 10 email addresses from a mysql database, how can I show them onto the page, in a form along other inputs (e.g. an email message) so there are inputs like $message and $from, and then post these form values to sendForm.php, collect them and send an email to each email address - individulaly?

 

My original idea was to send all the email addresses in a hidden field and collect them like this, but this obviously wont work becuase I'm sending other form data?

 

$postvars = array();

            foreach ($_POST as $interests => $value)
                  { 
                    $postvars[] = $value;
                    echo $value;
                   
                  }

 

any advice or tips??

 

thanks

[Barand]

try something like

<?php
$sql = "SELECT email FROM mytable";
$res =  mysql_query($sql);
while ($row = mysql_fetch_row($res))
{
    $e_ads[] = $row[0];
}
$to = join(';', $e_ads);
?>

[jas4]

yeh but then I want to send the $to string to a different form.

 

So can I just do this like:

 

<input type="hidden" value="<php echo $to; ?>">

 

and then use implode/explode at the other end? or is there a neter way to do it?

[Barand]

And the reason you can't put the "$to" variable from my example into a hidden field value is what?

[jas4]

erm i think thats what i did?? ^^^

 

<input type="hidden" value="<php echo $to; ?>">

 

[Barand]

Sorry, misread the post.

 

You need to name the hidden field

 

<input type="hidden" name="emailto" value="<php echo $to; ?>">

[jas4]

haha no worries.

 

 

 

so at the other end all I need to do is:

 

$email = $_POST['emailto']

 

which will be a string like:

 

email1@hotmail.com;email2@hotmail.com;email3@hotmail.com........

 

so would I explode/implode $email into an array and then loop through it if i wanted to send an email to each address individually?

 

thanks

[Barand]

yes, or you could prob send them all at once using the string as it is