Would this while statement work?

[Bman900]

I was wondering if this is correct or there is a better way of doing this?

 

<?php
$result = mysql_query("SELECT * FROM newsletter");


while($row = mysql_fetch_assoc( $result ))
{
    

$email = $row; 

mail($email, $subject, $message,"From: $from_email\n" . "MIME-Version: 1.0\n" . "Content-type: text/html; charset=iso-8859-1"); 

echo "$email was sent!";

} 

?>

 

[Ken2k7]

The while statement is correct; however, $row is an array, so...

[Jax2]

Is the only thing you need from the database the email?

 

You'll need to specify which row:

 

$email = $row['email'];

 

 

[Ken2k7]

Technically, that's a column, not a row. $row contains the array of results for the row.