Send emails to all member in database table

[manish009]

I have made a database using phprunner. All things have done but i am unable to put emails option to my database.
I want to send emails to all who are listed in one column of database.
I dont have any knowledge of php and html can you help in details. its too urgent.

Thank you
Manish Kumar
.

[ZetaPrints]

You can make use of PHP's mail() function to send an email for every data fetched by your query. Your code might look something like this:

Code: Select all

$query  = "SELECT email FROM contacts";
$result = mysql_query($query);

while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
   $to = $row['email'];  // from your database
    $subject = "Hello";
    $content = "Content of Email";
 
   if (mail($to, $subject, $body)) {
         echo("<p>Message successfully sent!</p>");
     } else {
         echo("<p>Message delivery failed...</p>");
     }
}