Mass Email

[kickit247]

I'm working on a small site for a business and have a database of all its customers and every customers email addresses and mailing address. Is it possible to use php for example to select every customer who lives in a certain city and with one click send an email to each one?

I really appreciate all your help and time!

Kevin

[Kudose]

<?php
$city = "Seattle";

$sql = mysql_query("SELECT email FROM table WHERE city='".$city."'");
$fetch = mysql_fetch_array($sql);

foreach($fetch as $to){
   mail($to, "Subject", "Body", "FROM: me <[e-mail]>");
}
?>

Viola. You'll need to modify it for your needs though.