Units Email Check

"; $email_html .= ""; $email_html .= ""; // get all units for fuel_supplier $email_html .= "

FUEL SUPPLIER

"; $fuel_supplier_res = $fuelsupplier_db->query("tanks", "SELECT * FROM `tanks` WHERE 1"); while ($fuel_supplier = $fuel_supplier_res->fetch_assoc()) { // get last unit heart beat $unit_res = $fuelsupplier_db->query("tank_level_log", "SELECT * FROM `tank_level_log` WHERE `tank_id` = '" . $fuel_supplier['record_id'] . "' ORDER BY `record_id` DESC LIMIT 1"); $unit = $unit_res->fetch_assoc(); $email_html .= ""; } $email_html .= "

{$fuel_supplier['name']}

{$unit['distance']}

{$unit['date_time_measured']}

"; // get all units for muell $email_html .= "

MUELL

"; $email_html .= ""; $muell_res = $muell_db->query("tanks", "SELECT * FROM `tanks` WHERE 1"); while ($muell = $muell_res->fetch_assoc()) { $unit_res = $muell_db->query("tank_level_log", "SELECT * FROM `tank_level_log` WHERE `tank_id` = '" . $muell['record_id'] . "' ORDER BY `record_id` DESC LIMIT 1"); $unit = $unit_res->fetch_assoc(); $email_html .= ""; } $email_html .= "

{$muell['name']}

{$unit['distance']}

{$unit['date_time_measured']}

"; // get all units for water $email_html .= "

WATER

"; $email_html .= ""; $water_res = $water_db->query("water", "SELECT * FROM `water` WHERE unit_id = 1 ORDER BY record_id DESC LIMIT 1"); $water = $water_res->fetch_assoc(); $email_html .= ""; $water_res = $water_db->query("water", "SELECT * FROM `water` WHERE unit_id = 2 ORDER BY record_id DESC LIMIT 1"); $water = $water_res->fetch_assoc(); $email_html .= ""; $water_res = $water_db->query("water", "SELECT * FROM `water` WHERE unit_id = 3 ORDER BY record_id DESC LIMIT 1"); $water = $water_res->fetch_assoc(); $email_html .= ""; $email = new email(); $email->add_address("chris@elegantwork.co.za", "Chris"); $email->add_address("henry@elegantwork.co.za", "Henry"); $email->add_address("sj@elegantwork.co.za", "SJ"); $email->subject("EWG UNITS MONITORING"); $email->body($email_html); echo $email_html; $email->send();

Sysie 3	{$water['date_time']}	{$water['count']}	{$water['tank']}
Sysie 6	{$water['date_time']}	{$water['count']}	{$water['tank']}
Sysie 5	{$water['date_time']}	{$water['count']}	{$water['tank']}