Jump to content

email script (will be cron job) not sending email


Recommended Posts

$sql="SELECT * FROM $tbl_name3 WHERE review_show='n'";
$result=mysql_query($sql);
$num_results=mysql_num_rows($result);
if($num_results > 1){
$message="You have ".$num_results." reviews unapproved.";
mail('[email protected]','GHP Reviews', $message, 'From: [email protected]');
}

$sql2="SELECT * FROM $tbl_name4 WHERE rma_issued='n'";
$result2=mysql_query($sql2);
$num_results2=mysql_num_rows($result2);
if($num_results2 > 1){
$message="You have ".$num_results2." RMA Numbers Requested.";
mail('[email protected]','GHP RMA Number Requests', $message, 'From: [email protected]');
}

 

The reviews email is being sent, however, the RMA email is not.

 

EDIT: Nevermind, $num_results and $num_results2 should have been > 0 not > 1.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.