Mass Mailing Script!

Hi all,

I have the following code…

[code=php]<?php

// specify includes
$fp = ‘../’;
require_once($fp . ‘functions/database.php’);
require_once($fp . ‘functions/mail.php’);

// ——————–

// read message
$filename = ‘june-test.php’;
$handle = fopen($filename, ‘r’);
$html = fread($handle, filesize($filename));
fclose($handle);

// query for customer data
$q = “SELECT * FROM customer WHERE email_opt = 1”; // returns around 2000 lines
$result = queryDatabase($q);
echo ‘<p>numRows: ‘ . mysql_num_rows($result) . ‘</p>’;
while ($row = mysql_fetch_array($result))
{
// format message
$message = str_replace(‘[first]’, $row[‘first_name’], $html);
$message = str_replace(‘[last]’, $row[‘last_name’], $message);
$message = str_replace(‘[email]’, $row[’email_address’], $message);

// send mail
$mailResult = sendMail($row[’email_address’], ‘15% off everything!’, $message, ‘Outlook Images <[email protected]>’);

// output result
echo ‘<p>’ . $mailResult . ‘ – ‘ . $row[’email_address’] . ‘</p>’;
}

?>[/code]

…however when I run it I get a 500 internal server error. Any ideas why?

Thanks,

dai.hop

Also in #PHP _↴