Untitled

MySQL to Populate Foreach
$run = mysql_query("SELECT email FROM newsletter");

    foreach ($run as $value) {
        mail($value, $subject, $_POST['message'], $headers);
    }

$run = mysql_query("SELECT email FROM newsletter");
    $email = mysql_fetch_array($run, MYSQL_ASSOC)
    $cols = implode (', ', $email);
    $run2 = mysql_query("SELECT $cols FROM newsletter");
    while($emaillist = mysql_fetch_array($run2, MYSQL_ASSOC)){
        foreach ($emaillist as $value) {
            mail($value, $subject, $_POST['message'], $headers);
        }
    }

$handle = mysql_query("SELECT email FROM newsletter");

while ($row = mysql_fetch_assoc( $handle ) )
{
    mail( $row['email'], $subject, $_POST['message'], $headers);
}

$run = mysql_query("SELECT email FROM newsletter");

foreach ($run as $value) {
    mail($value, $subject, $_POST['message'], $headers);
}

$result = mysql_query("SELECT body, emailaddress, subject  FROM emails");
if (!$result) { die('error in mysql_query: '.mysql_error())}
while ($row = mysql_fetch_array($result) {
  $body = $row['body'];
  $address = $row['address'];
  $subject = $row['subject'];
  //do stuff with that data.
  //never use $_POST data directly, always feed it though `htmlentities`
  //before outputting it (screen or email)
  //or through mysql_real_escape_string() before inputting it in a DB.
  $echo htmlentities($body);  //sanitize your output or suffer XSS-attacks
  .....
}

SELECT e.body, e.subject, e.header, e.whatever FROM emails e
INNER JOIN newsletter n ON (n.id = e.newsletter_id)
WHERE n.id = 1466