db_query to email

[georgehowell]

hi there

there seems to be lots of code out there for saving email content to a database, but what about sourcing email addresses from a database to compile mailouts?

Here's my first attempt (which doesn't work), but i'm just a student (sorry)...

 

<?php

$database = "skyzone";

$username = "root";

$password = "";

// connect to database

$db = new PDO("mysql:host=localhost;dbname=$database",$username,$password);

//query database

$result = db_query("SELECT email FROM users WHERE subscribe = '1'", $emails);

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

$to = $emails;

$subject = "SkyZone Newsletter";

$body = "Newsletter.pdf";

if (mail($to, $subject, $body)) {

  echo("<p>Message successfully sent!</p>");

  } else {

  echo("<p>Message delivery failed...</p>");

  }

}

 

 

Does any body know?

 

cheers, George

[ChemicalBliss]

$to = $emails;

 

Grab the email from the row your looping from:

 

$to = $row['email'];

 

-cb-

[georgehowell]

thanx ChemicalBlis

it works!

you're a very considerate gentleman. May you have decades of good fortune

[oni-kun]

thanx ChemicalBlis

it works!

you're a very considerate gentleman. May you have decades of good fortune

 

I want what he has.