Here is the script I am trying to get Cron to execute.
<?
require_once("config.php");
$newsletter_send = mysql_connect("$database_server","$database_username","$database_password");
mysql_select_db("$database_name");
$sql = "SELECT * FROM ".$database_prefix."_subscribe";
$result = mysql_query($sql);
While ($row = mysql_fetch_array($result)) {
$email = $row['Email'];
$name = $row['Name'];
$from_name = "Name";
$from_email = "noreply@yoursite.com";
$subject = "Subject";
$from = "$from_name <$from_email>";
$to = "$name <$email>";
$process_template = fopen("http://www.mysite.com/newsletter/process_template.php", "r");
$message = fread($process_template, 2000000);
$headers = "MIME-Version: 1.0\r\n";
$headers .= "Content-type: text/html; charset=iso-8859-1\r\n";
$headers .= "From: $from_name <$from_email>\r\n";
$headers .= "Return-Path: $from_name <$from_email>\r\n";
$send = mail($to, $subject, $message, $headers);
$send;
if ($send) {
echo("Mail sent successfully: $email<br>");
$date = date("m/d/y - g:i a T");
$output = 'Success: ' .$email. ' (' .$date. ')
';
$file = fopen("/home/leafs/newsletter/newsletter.log", "a");
fputs($file, $output);
fclose($file);
} else {
echo("Error sending email: $email");
$date = date("m/d/y - g:i a T");
$output = 'ERROR: ' .$email. ' (' .$date. ')
';
$file = fopen("/home/leafs/newsletter/newsletter.log", "a");
fputs($file, $output);
fclose($file);
}
}
mysql_close($newsletter_send);
?>
The cron definetly works! I have overwritten this script with another to prove that the cron is working.
When this script is executed by me, it works great! However, CRON just isn't executing it does nothing...
Can anyone figure out why?
