diff -r 69fadd1aded2 -r 5e2424bfbc4a www/getbrewlog.php --- a/www/getbrewlog.php Tue Feb 26 16:18:16 2019 +0100 +++ b/www/getbrewlog.php Wed Feb 27 14:39:25 2019 +0100 @@ -13,22 +13,22 @@ } mysqli_set_charset($connect, "utf8" ); -$query = "SELECT * FROM log_brews WHERE product_code='".$code."' ORDER BY datetime;"; +$query = "SELECT * FROM log_brews WHERE code='".$code."' ORDER BY datetime;"; $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { $lines[] = array( 'record' => $row['record'], 'date' => substr($row['datetime'],0,16), 'version' => $row['version'], - 'code' => $row['product_code'], - 'name' => $row['product_name'], - 'pv_mlt' => $row['temperature_mlt'], - 'pv_bk' => $row['temperature_bk'], - 'pv_hlt' => $row['temperature_hlt'], - 'pv_room' => $row['temperature_room'], - 'sp_mlt' => $row['setpoint_mlt'], - 'sp_bk' => $row['setpoint_bk'], - 'sp_hlt' => $row['setpoint_hlt'], + 'code' => $row['code'], + 'name' => $row['name'], + 'pv_mlt' => $row['pv_mlt'], + 'pv_hlt' => $row['pv_hlt'], + 'pv_room' => $row['pv_room'], + 'sp_mlt' => $row['sp_mlt'], + 'sp_hlt' => $row['sp_hlt'], + 'pwm_mlt' => $row['pwm_mlt'], + 'pwm_hlt' => $row['pwm_hlt'], 'event' => $row['event'] ); }