Gegevens uit een database gebruiken voor verzenden.

<strong>Naam tabel</strong>
     <select name="to">
    <option value="">Maak uw keuze</option>
    <option value="tabel1">tabel1</option>
    <option value="tabel2">tabel2</option>
     .........
     </select> 
<?php
include "connect.php";
$query = mysql_query("SELECT emailadres FROM $to");
while ($result = mysql_fetch_row($query))
{
  // Header maken
  $header .= "From: \"Mij\" <email@adres.nl>\r\n";
  // Bericht maken
  $bericht = "Hoi\n\n";
  $bericht .= "Blalblablal\n";
  // Onderwerp
  $onderwerp = "Mailtje!";
  // Mailen
  mail($result[0],$onderwerp,$bericht,$header);
}
?> 

<strong>Naam tabel</strong>
     <select name="to">
    <option value="">Maak uw keuze</option>
    <option value="tabel1">tabel1</option>
    <option value="tabel2">tabel2</option>
     .........
     </select> 
<?php
include "connect.php";
$query = mysql_query("SELECT emailadres FROM $to");
while ($result = mysql_fetch_row($query))
{
  // Header maken
  $header .= "From: \"Mij\" <email@adres.nl>\r\n";
  // Bericht maken
  $bericht = "Hoi\n\n";
  $bericht .= "Blalblablal\n";
  // Onderwerp
  $onderwerp = "Mailtje!";
  // Mailen
  mail($result[0],$onderwerp,$bericht,$header);
}
?>

<?php
$query = "SELECT naam, emailadres FROM tabelnaam";
//query is aangemaakt
$sql = mysql_query($query) or die ( mysql_error( ) );
//query is uitgevoerd
echo 'selecteer naam ontvanger: ' . '<select name="to">';
while($record = mysql_fetch_assoc($sql)){
 echo '<option value="'.$record['emailadres'].'">'.$record['naam'].'</option>';

}
echo '</select>';

?>

<?php
$query = "SELECT naam, emailadres FROM tabelnaam";
//query is aangemaakt
$sql = mysql_query($query) or die ( mysql_error( ) );
//query is uitgevoerd
echo 'selecteer naam ontvanger: ' . '<select name="to">';
while($record = mysql_fetch_assoc($sql)){
 echo '<option value="'.$record['emailadres'].'">'.$record['naam'].'</option>';
 
}
echo '</select>';
 
?>

<?php
$query = "SELECT naam, emailadres FROM tabelnaam";
//query is aangemaakt
$sql = mysql_query($query) or die ( mysql_error( ) );
//query is uitgevoerd
echo 'selecteer naam ontvanger: ' . '<select multiple name="to">';
while($record = mysql_fetch_assoc($sql)){
 echo '<option value="'.$record['emailadres'].'">'.$record['naam'].'</option>';

}
echo '</select>';

?>

<?php
$query = "SELECT naam, emailadres FROM tabelnaam";
//query is aangemaakt
$sql = mysql_query($query) or die ( mysql_error( ) );
//query is uitgevoerd
echo 'selecteer naam ontvanger: ' . '<select multiple name="to">';
while($record = mysql_fetch_assoc($sql)){
 echo '<option value="'.$record['emailadres'].'">'.$record['naam'].'</option>';
 
}
echo '</select>';
 
?>