Please help me. I have been trying to get this script to:

1. Scan my MySQL table with 4 email fields

2. Send html message to email 1 at a time (to be be regarded as spam)

3. Loop back to the top when reach the last email and start over every 2 weeks

4. schedule to run at night around 2, 3am.

5. Include one image at the top and a couple at the bottom.

please help. Here's what I have so far.

$headers = 'From: email@example.com' . "\r\n" .
'Reply-To: email@example.com' . "\r\n" .
'X-Mailer: php/' . phpversion();

mysql_select_db($database_authenticate, $authenticate);

$result = mysql_query("SELECT email1, email2,email3,email4, FROM users WHERE sub = $sub");

if(mysql_num_rows($result) > 0)
{
$count = 0;
while ($row = mysql_fetch_array ($result, mysql_ASSOC))
{

$to = $row['email1'] . ', ';
$to = $row['email2'] . ', ';
$to = $row['email3'] . ', ';
$to .= $row['email4'];
mail($to, $subject, $message, $headers);
$count++;
}
echo "myResult=$count Emails Sent.";
}
else
{
echo "myResult=Email Submissions Failed.";
}

Firstly, you mentioned that you're sending spam... spam is evil, and the people that send spam deserve to go to jail for violating the 1988 Data Protection Act.

But anyway, here's a few things to think about. PHP can't schedule itself to execute on a certain date, as PHP is a called upon script (it will only execute when you, or the server, executes it) so for this reason you need to use Cron Jobs to get the server to execute the script and email you the results. http://www.webmaster-talk.com/showthread.php?t=32191

Also, if you're sending mass emails i take it you're using the mail() function in PHP, be warned this can cause massive time out and some emails may not be sent and your service provider may bust you for trying to send mass emails out - so you'll need to look into sockets so that you can keep one open long enough for the script to execute fully.

And the image thing, it's simple HTML if you're not going to attach it to the email - and if you are going to attach it to the email it wont make it past most people SpamWare.