$email = "blah@gmail.com";
$subject = "NAIS Weekly Training Expiring Report"; 
$message = "
<center><font color=green> SALT LAKE CITY TRAINING EXPIRING REPORT<p></font>
Expiring Driver Licenses<p>
$driverlicensemail

";
mail($email, $subject, $message, "From: Me Services Group<blah@gmail.com>\n 
X-Mailer: PHP/" . phpversion());

<?php

$dbhandle = mysql_connect($hostname, $username, $password)
or die("Unable to connect to MySQL");

$selected = mysql_select_db("clintona_SLC",$dbhandle)
or die("Can not open SLC Database");

$result = mysql_query("SELECT * FROM training ORDER BY lname");

$nowtrue = date('Y-m-d');

echo "Salt Lake City Expiring Training Report - If nothing is below there are no actions needed:<p>";

while ($row=mysql_fetch_assoc($result)){ extract($row);

$driverslicense = strtotime($driverslicense.'- 1 month');

$driverslicense = date('Y-m-d',$driverslicense);

$driverslicenseexpire = strtotime($driverslicense.'+ 1 month');

$driverslicenseexpire = date('n/j/Y',$driverslicenseexpire);

if ($row{'driverslicense'}=='0000-00-00') echo " "; 

elseif ($nowtrue > $driverslicense) {    
echo "<center> $fname $lname is due for a Drivers License renewal! It Expires $driverslicenseexpire
";
$driverlicensemail .= "<center> $fname $lname - Expires $driverslicenseexpire </center> <br>
"; 
}


$cdl = strtotime($driverslicense.'- 1 month');

$cdl = date('Y-m-d',$cdl);

$cdlexpire = strtotime($cdlexpire.'+ 1 month');

$cdlexpire = date('n/j/Y',$cdlexpire);

if ($row{'cdl'}=='0000-00-00') echo " "; 

elseif ($nowtrue > $cdl) {    
echo "<center> $fname $lname is due for a CDL renewal! It Expires $cdlexpire
";
$cdlmail .= "<center> $fname $lname - Expires $cdlexpire </center> <br>
"; 
}


$cdlmedicalexpire = strtotime($cdlmedical.'+ 24 months');

$cdlmedicalexpire = date('n/j/Y',$cdlmedicalexpire);

$cdlmedical = strtotime($cdlmedical.'+ 23 months');

$cdlmedical = date('Y-m-d',$cdlmedical);

if ($row{'cdlmedical'}=='0000-00-00') echo " "; 

elseif($nowtrue > $cdlmedical) {
echo "<center> $fname $lname is due for a CDL Medical Evaluation! It Expires $cdlmedicalexpire
";
$cdlmedicalmail .= "<center> $fname $lname - Expires $cdlmedicalexpire </center> <br>
"; 
}


$hazmatmedicalexpire = strtotime($hazmatmedical.'+ 12 months');

$hazmatmedicalexpire = date('n/j/Y',$hazmatmedicalexpire);

$hazmatmedical = strtotime($hazmatmedical.'+ 11 months');

$hazmatmedical = date('Y-m-d',$hazmatmedical);

if ($row{'hazmatmedical'}=='0000-00-00') echo " "; 

elseif($nowtrue > $hazmatmedical) {
echo "<center> $fname $lname is due for a HazMat Medical Evaluation! It Expires $hazmatmedicalexpire
";
$hazmatmedicalmail .= "<center> $fname $lname - Expires $hazmatmedicalexpire </center> <br>
"; 
}


$kucccontractorexpire = strtotime($kucccontractor.'+ 12 months');

$kucccontractorexpire = date('n/j/Y',$kucccontractorexpire);

$kucccontractor = strtotime($kucccontractor.'+ 11 months');

$kucccontractor = date('Y-m-d',$kucccontractor);

if ($row{'kucccontractor'}=='0000-00-00') echo " "; 

elseif ($nowtrue > $kucccontractor) {
echo "<center> $fname $lname is due for KUCC Contractor Orientation! It Expires $kucccontractorexpire
";
$kucccontractormail .= "<center> $fname $lname - Expires $kucccontractorexpire </center> <br>
"; 
}

$kuccehsplanexpire = strtotime($kuccehsplan.'+ 12 months');

$kuccehsplanexpire = date('n/j/Y',$kuccehsplanexpire);

$kuccehsplan = strtotime($kuccehsplan.'+ 11 months');

$kuccehsplan = date('Y-m-d',$kuccehsplan);

if ($row{'kuccehsplan'}=='0000-00-00') echo " "; 

elseif($nowtrue > $kuccehsplan) {
echo "<center> $fname $lname is due to renew the KUCC Personal EH & S Plan! It Expires $kuccehsplanexpire
";
$kuccehsplanmail .= "<center> $fname $lname - Expires $kuccehsplanexpire </center> <br>
"; 
}

$kuccconcentratorexpire = strtotime($kuccconcentrator.'+ 12 months');

$kuccconcentratorexpire = date('n/j/Y',$kuccconcentratorexpire);

$kuccconcentrator = strtotime($kuccconcentrator.'+ 11 months');

$kuccconcentrator = date('Y-m-d',$kuccconcentrator);

if ($row{'kuccconcentrator'}=='0000-00-00') echo " "; 

elseif ($nowtrue > $kuccconcentrator) {
echo "<center> $fname $lname is due for the KUCC Hazard Recognition Concentrator Program! It Expires $kuccconcentratorexpire
";
$kuccconcentratormail .= "<center> $fname $lname - Expires $kuccconcentratorexpire </center> <br>
"; 
}

$kuccmineexpire = strtotime($kuccmine.'+ 12 months');

$kuccmineexpire = date('n/j/Y',$kuccmineexpire);

$kuccmine = strtotime($kuccmine.'+ 11 months');

$kuccmine = date('Y-m-d',$kuccmine);

if ($row{'kuccmine'}=='0000-00-00') echo " "; 

elseif($nowtrue > $kuccmine) {
echo "<center> $fname $lname is due for the KUCC Hazard Recognition Mine & Copperton Program! It Expires $kuccmineexpire
";
$kuccminemail .= "<center> $fname $lname - Expires $kuccmineexpire </center> <br>
"; 
}

$kuccuppexpire = strtotime($kuccupp.'+ 12 months');

$kuccuppexpire = date('n/j/Y',$kuccuppexpire);

$kuccupp = strtotime($kuccupp.'+ 11 months');

$kuccupp = date('Y-m-d',$kuccupp);

if ($row{'kuccupp'}=='0000-00-00') echo " "; 

elseif ($nowtrue > $kuccupp) {
echo "<center> $fname $lname is due for the KUCC Hazard Recognition UPP Program! It Expires $kuccuppexpire
";
$kuccuppmail .= "<center> $fname $lname - Expires $kuccuppexpire </center> <br>
"; 
}

$kuccpmetalsexpire = strtotime($kuccpmetals.'+ 12 months');

$kuccpmetalsexpire = date('n/j/Y',$kuccpmetalsexpire);

$kuccpmetals = strtotime($kuccpmetals.'+ 11 months');

$kuccpmetals = date('Y-m-d',$kuccpmetals);

if ($row{'kuccpmetals'}=='0000-00-00') echo " "; 

elseif($nowtrue > $kuccpmetals) {
echo "<center> $fname $lname is due for the KUCC Hazard Recognition Precious Metals Program! It Expires $kuccpmetalsexpire
";
$kuccpmetalsmail .= "<center> $fname $lname - Expires $kuccpmetalsexpire </center> <br>
"; 
}


$kuccpitexpire = strtotime($kuccpit.'+ 12 months');

$kuccpitexpire = date('n/j/Y',$kuccpitexpire);

$kuccpit = strtotime($kuccpit.'+ 11 months');

$kuccpit = date('Y-m-d',$kuccpit);

if ($row{'kuccpit'}=='0000-00-00') echo " "; 

elseif ($nowtrue > $kuccpit) {
echo "<center> $fname $lname is due for the KUCC Pit License! It Expires $kuccpitexpire <p></center>";
$kuccpitmail .= "<center> $fname $lname - Expires $kuccpitexpire </center> <br>
"; 
}

$msha46expire = strtotime($msha46.'+ 12 months');

$msha46expire = date('n/j/Y',$msha46expire);

$msha46 = strtotime($msha46.'+ 11 months');

$msha46 = date('Y-m-d',$msha46);

if ($row{'msha46'}=='0000-00-00') echo " "; 

elseif($nowtrue > $msha46) {
echo "<center> $fname $lname is due for MSHA Part 46 Training! It Expires $msha46expire
";
$msha46mail .= "<center> $fname $lname - Expires $msha46expire </center> <br>
"; 
}

$msha48expire = strtotime($msha48.'+ 12 months');

$msha48expire = date('n/j/Y',$msha48expire);

$msha48 = strtotime($msha48.'+ 11 months');

$msha48 = date('Y-m-d',$msha48);

if ($row{'msha48'}=='0000-00-00') echo " "; 

elseif ($nowtrue > $msha48) {
echo "<center> $fname $lname is due for MSHA Part 48 Training! It Expires $msha48expire
";
$msha48mail .= "<center> $fname $lname - Expires $msha48expire </center> <br>
"; 
}

$mvrcheckexpire = strtotime($mvrcheck.'+ 6 months');

$mvrcheckexpire = date('n/j/Y',$mvrcheckexpire);

$mvrcheck = strtotime($mvrcheck.'+ 5 months');

$mvrcheck = date('Y-m-d',$mvrcheck);

if ($row{'mvrcheck'}=='0000-00-00') echo " "; 

elseif($nowtrue > $mvrcheck) {
echo "<center> $fname $lname is due for an MVR Check! It Expires $mvrcheckexpire
";
$mvrcheckmail .= "<center> $fname $lname - Expires $mvrcheckexpire </center> <br>
"; 
}

$respiratorfitexpire = strtotime($respiratorfit.'+ 12 months');

$respiratorfitexpire = date('n/j/Y',$respiratorfitexpire);

$respiratorfit = strtotime($respiratorfit.'+ 11 months');

$respiratorfit = date('Y-m-d',$respiratorfit);

if ($row{'respiratorfit'}=='0000-00-00') echo " "; 

elseif ($nowtrue > $respiratorfit) {
echo "<center> $fname $lname is due for a Respirator Fit Test! It Expires $respiratorfitexpire
";
$respiratorfitmail .= "<center> $fname $lname - Expires $respiratorfitexpire </center> <br>
"; 
}

$respiratormedicalexpire = strtotime($respiratormedical.'+ 12 months');

$respiratormedicalexpire = date('n/j/Y',$respiratormedicalexpire);

$respiratormedical = strtotime($respiratormedical.'+ 11 months');

$respiratormedical = date('Y-m-d',$respiratormedical);

if ($row{'respiratormedical'}=='0000-00-00') echo " "; 

elseif($nowtrue > $respiratormedical) {
echo "<center> $fname $lname is due for a Respirator Medical Evaluation! It Expires $respiratormedicalexpire
";
$respiratormedicalmail .= "<center> $fname $lname - Expires $respiratormedicalexpire </center> <br>
"; 
}

$substance9expire = strtotime($substance9.'+ 12 months');

$substance9expire = date('n/j/Y',$substance9expire);

$substance9 = strtotime($substance9.'+ 11 months');

$substance9 = date('Y-m-d',$substance9);

if ($row{'substance9'}=='0000-00-00') echo " "; 

elseif($nowtrue > $substance9) {
echo "<center> $fname $lname is due for a NIDA 9-Panel Drug Test! It Expires $substance9expire
";
$substance9mail .= "<center> $fname $lname - Expires $substance9expire </center> <br>
"; 
}

$naislifttruckexpire = strtotime($naislifttruck.'+ 24 months');

$naislifttruckexpire = date('n/j/Y',$naislifttruckexpire);

$naislifttruck = strtotime($naislifttruck.'+ 23 months');

$naislifttruck = date('Y-m-d',$naislifttruck);

if ($row{'naislifttruck'}=='0000-00-00') echo " "; 

elseif($nowtrue > $naislifttruck) {
echo "<center> $fname $lname is due for the NAIS Task Training Lift Truck Training! It Expires $naislifttruckexpire
";
$naislifttruckmail .= "<center> $fname $lname - Expires $naislifttruckexpire </center> <br>
"; 
}

$naisoverheadcraneexpire = strtotime($naisoverheadcrane.'- 1 month');

$naisoverheadcraneexpire = date('Y-m-d',$naisoverheadcraneexpire);

$naisoverheadcrane = strtotime($naisoverheadcrane.'+ 1 month');

$naisoverheadcrane = date('n/j/Y',$naisoverheadcrane);

if ($row{'naisoverheadcrane'}=='0000-00-00') echo " "; 

elseif($nowtrue > $naisoverheadcrane) {
echo "<center> $fname $lname is due for Overhead Crane Re-Training! It Expires $naisoverheadcrane
";
$naisoverheadcranemail .= "<center> $fname $lname - Expires $naisoverheadcraneexpire </center> <br>
"; 
}

$fmchazexpire = strtotime($fmchaz.'+ 12 months');

$fmchazexpire = date('n/j/Y',$fmchazexpire);

$fmchaz = strtotime($fmchaz.'+ 11 months');

$fmchaz = date('Y-m-d',$fmchaz);

if ($row{'fmchaz'}=='0000-00-00') echo " "; 

elseif($nowtrue > $fmchaz) {
echo "<center> $fname $lname is due for FMC Corp. Retraining! It Expires $fmchazexpire
";
$fmchazmail .= "<center> $fname $lname - Expires $fmchazexpire </center> <br>
"; 
}

$solvayhazexpire = strtotime($solvayhaz.'+ 12 months');

$solvayhazexpire = date('n/j/Y',$solvayhazexpire);

$solvayhaz = strtotime($solvayhaz.'+ 11 months');

$solvayhaz = date('Y-m-d',$solvayhaz);

if ($row{'solvayhaz'}=='0000-00-00') echo " "; 

elseif($nowtrue > $solvayhaz) {
echo "<center> $fname $lname is due for Solvay Chemicals Retraining! It Expires $solvayhazexpire
";
$solvayhazmail .= "<center> $fname $lname - Expires $solvayhazexpire </center> <br>
"; 
}

$barrickhazexpire = strtotime($barrickhaz.'+ 12 months');

$barrickhazexpire = date('n/j/Y',$barrickhazexpire);

$barrickhaz = strtotime($barrickhaz.'+ 11 months');

$barrickhaz = date('Y-m-d',$barrickhaz);

if ($row{'barrickhaz'}=='0000-00-00') echo " "; 

elseif($nowtrue > $barrickhaz) {
echo "<center> $fname $lname is due for Barrick Goldstrike Retraining! It Expires $barrickhazexpire
";
$barrickhazmail .= "<center> $fname $lname - Expires $barrickhazexpire </center> <br>
"; 
}

$uitchazexpire = strtotime($uitchaz.'+ 12 months');

$uitchazexpire = date('n/j/Y',$uitchazexpire);

$uitchaz = strtotime($uitchaz.'+ 11 months');

$uitchaz = date('Y-m-d',$uitchaz);

if ($row{'uitchaz'}=='0000-00-00') echo " "; 

elseif($nowtrue > $uitchaz) {
echo "<center> $fname $lname is due for UITC Retraining! It Expires $uitchazexpire
";
$uitchazmail .= "<center> $fname $lname - Expires $uitchazexpire </center> <br>
"; 
}

$newmonthazexpire = strtotime($newmonthaz.'+ 12 months');

$newmonthazexpire = date('n/j/Y',$newmonthazexpire);

$newmonthaz = strtotime($newmonthaz.'+ 11 months');

$newmonthaz = date('Y-m-d',$newmonthaz);

if ($row{'newmonthaz'}=='0000-00-00') echo " "; 

elseif($nowtrue > $newmonthaz) {
echo "<center> $fname $lname is due for Newmont Retraining! It Expires $newmonthazexpire 
";
$newmonthazmail .= "<center> $fname $lname - Expires $newmonthazexpire </center> <br>
"; 
}

$genchemhazexpire = strtotime($genchemhaz.'+ 12 months');

$genchemhazexpire = date('n/j/Y',$genchemhazexpire);

$genchemhaz = strtotime($genchemhaz.'+ 11 months');

$genchemhaz = date('Y-m-d',$genchemhaz);

if ($row{'genchemhaz'}=='0000-00-00') echo " "; 

elseif($nowtrue > $genchemhaz) {
echo "<center> $fname $lname is due for General Chemicals Retraining! It Expires $genchemhazexpire
";
$genchemhazmail .= "<center> $fname $lname - Expires $genchemhazexpire </center> <br>
"; 
}

$hazwoper40expire = strtotime($hazwoper40.'+ 12 months');

$hazwoper40expire = date('n/j/Y',$hazwoper40expire);

$hazwoper40 = strtotime($hazwoper40.'+ 11 months');

$hazwoper40 = date('Y-m-d',$hazwoper40);

if ($row{'hazwoper40'}=='0000-00-00') echo " "; 

elseif($nowtrue > $hazwoper40) {
echo "<center> $fname $lname is due for 8-Hour Hazwoper Refresher training! It Expires $hazwoper40expire
";
$hazwoper40mail .= "<center> $fname $lname - Expires $hazwoper40expire </center> <br>
"; 
}

$hazwoper24expire = strtotime($hazwoper24.'+ 12 months');

$hazwoper24expire = date('n/j/Y',$hazwoper24expire);

$hazwoper24 = strtotime($hazwoper24.'+ 11 months');

$hazwoper24 = date('Y-m-d',$hazwoper24);

if ($row{'hazwoper24'}=='0000-00-00') echo " "; 

elseif($nowtrue > $hazwoper24) {
echo "<center> $fname $lname is due for 8-Hour Hazwoper Refresher training! It Expires $hazwoper24expire
";
$hazwoper24mail .= "<center> $fname $lname - Expires $hazwoper24expire </center> <br>
"; 
}

$firstaidcprexpire = strtotime($firstaidcpr.'+ 12 months');

$firstaidcprexpire = date('n/j/Y',$firstaidcprexpire);

$firstaidcpr = strtotime($firstaidcpr.'+ 11 months');

$firstaidcpr = date('Y-m-d',$firstaidcpr);

if ($row{'firstaidcpr'}=='0000-00-00') echo " "; 

elseif($nowtrue > $firstaidcpr) {
echo "<center>
$fname $lname is due for a First-Aid/CPR Refresher Course! It Expires $firstaidcprexpire
";
$firstaidcprmail .= "<center> $fname $lname - Expires $firstaidcprexpire </center> <br>
"; 

}}

$email = 'blah@gmail.com,blah@hotmail.com';
$subject = 'NAIS Weekly Training Expiring Report'; 
$message .= '
<html>
<center><font color=green><h2> LAKE CITY TRAINING EXPIRING REPORT </h2><p></font>
<b><font color=blue>Driver Licenses</b></font><p></html>';
$message .= $driverlicensemail;
$message .= '<p><b><center><font color=blue>CDL\'s</b></font><p></html>';
$message .= $cdlmail;
$message .= '<p><b><center><font color=blue>CDL Medical Evaluation</b></font><p></html>';
$message .= $cdlmedicalmail;
$message .= '<p><b><center><font color=blue>HAZMAT Medical Evaluation</b></font><p></html>';
$message .= $hazmatmedicalmail;
$message .= '<p><b><center><font color=blue>Kennecott Contractor Training</b></font><p></html>';
$message .= $kucccontractormail;
$message .= '<p><b><center><font color=blue>Kennecott EH&S Plan</b></font><p></html>';
$message .= $kuccehsplanmail;
$message .= '<p><b><center><font color=blue>Kennecott Concentrator Training</b></font><p></html>';
$message .= $kuccconcentratormail;
$message .= '<p><b><center><font color=blue>Kennecott Mine Training</b></font><p></html>';
$message .= $kuccminemail;
$message .= '<p><b><center><font color=blue>Kennecott UPP Training</b></font><p></html>';
$message .= $kuccuppmail;
$message .= '<p><b><center><font color=blue>Kennecott Precious Metals Training</b></font><p></html>';
$message .= $kuccpmetalsmail;
$message .= '<p><b><center><font color=blue>Kennecott Pit Training</b></font><p></html>';
$message .= $kuccpitmail;
$message .= '<p><b><center><font color=blue>MSHA Part 46 Training</b></font><p></html>';
$message .= $msha46mail;
$message .= '<p><b><center><font color=blue>MSHA Part 48 Training</b></font><p></html>';
$message .= $msha48mail;
$message .= '<p><b><center><font color=blue>MVR Check</b></font><p></html>';
$message .= $mvrcheckmail;
$message .= '<p><b><center><font color=blue>Respirator Fit Test</b></font><p></html>';
$message .= $respiratorfitmail;
$message .= '<p><b><center><font color=blue>Respirator Medical Evaluation</b></font><p></html>';
$message .= $respiratormedicalmail;
$message .= '<p><b><center><font color=blue>9-Panel Substance Abust Test</b></font><p></html>';
$message .= $substance9mail;
$message .= '<p><b><center><font color=blue>NAIS Lift Truck Training</b></font><p></html>';
$message .= $naislifttruckmail;
$message .= '<p><b><center><font color=blue>NAIS Overhead Crane Training</b></font><p></html>';
$message .= $naisoverheadcranemail;
$message .= '<p><b><center><font color=blue>FMC Site Training</b></font><p></html>';
$message .= $fmchazmail;
$message .= '<p><b><center><font color=blue>Solvay Site Training</b></font><p></html>';
$message .= $solvayhazmail;
$message .= '<p><b><center><font color=blue>Barrick Site Training</b></font><p></html>';
$message .= $barrickhazmail;
$message .= '<p><b><center><font color=blue>UITC Site Training</b></font><p></html>';
$message .= $uitchazmail;
$message .= '<p><b><center><font color=blue>Newmont Site Training</b></font><p></html>';
$message .= $newmonthazmail;
$message .= '<p><b><center><font color=blue>General Chemical Site Training</b></font><p></html>';
$message .= $genchemhazmail;
$message .= '<p><b><center><font color=blue>HAZWOPER 40</b></font><p></html>';
$message .= $hazwoper40mail;
$message .= '<p><b><center><font color=blue>HAZWOPER 24</b></font><p></html>';
$message .= $hazwoper24mail;
$message .= '<p><b><center><font color=blue>First Aid & CPR</b></font><p></html>';
$message .= $firstaidcprmail;

$headers  = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
$headers .= 'From: MeServices Group <blah@gmail.com>' . "\r\n";
mail($email, $subject, $message, $headers);

?>