Code: Select all
<?php
include 'config.php';
include 'opendb.php';
$query = "SELECT id, username, subject, date, status, escalated FROM `helpdesk` WHERE `date` < CURDATE()-14 and status LIKE '%Open' and escalated is NULL";
$result = mysql_query($query) or die('Error : ' . mysql_error());
$numrows = 0;
$numrows = mysql_num_rows($result);
while (list($id, $username, $subject1, $date, $status, $escalated) = mysql_fetch_array($result, MYSQL_NUM)) {
$message = "$id";
};
$to = "me@me.com";
$subject = "Call Updates";
$email = "test@test.com";
$headers = "From: $email";
$sent = mail($to, $subject, $message, $headers) ;
if($sent)
{print "Your mail was sent successfully"; }
else
{print "We encountered an error sending your mail"; }
include 'closedb.php';
?>