diff -r 8853fd62ac6f -r b4bfed3684d0 www/includes/db_product.php --- a/www/includes/db_product.php Sun Dec 29 14:43:04 2019 +0100 +++ b/www/includes/db_product.php Fri Jan 03 15:21:22 2020 +0100 @@ -563,7 +563,7 @@ } if (isset($_GET['select']) && ($_GET['select'] == "archname")) { - $query = "SELECT record,name,code,brew_date_start,st_name,og,fg,batch_size FROM products WHERE stage = '11' ORDER BY name,brew_date_start;"; + $query = "SELECT record,name,code,brew_date_start,st_name,brew_fermenter_sg,fg,batch_size FROM products WHERE stage = '11' ORDER BY name,brew_date_start;"; $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { $brews[] = array( @@ -572,7 +572,7 @@ 'code' => $row['code'], 'date' => substr($row['brew_date_start'], 0, 10), 'style' => $row['st_name'], - 'og' => $row['og'], + 'og' => $row['brew_fermenter_sg'], 'fg' => $row['fg'], 'batch_size' => $row['batch_size'] ); @@ -583,7 +583,7 @@ } if (isset($_GET['select']) && ($_GET['select'] == "archcode")) { - $query = "SELECT record,name,code,brew_date_start,st_name,og,fg,batch_size FROM products WHERE stage = '11' ORDER BY code;"; + $query = "SELECT record,name,code,brew_date_start,st_name,brew_fermenter_sg,fg,batch_size FROM products WHERE stage = '11' ORDER BY code;"; $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { $brews[] = array( @@ -592,7 +592,7 @@ 'code' => $row['code'], 'date' => substr($row['brew_date_start'], 0, 10), 'style' => $row['st_name'], - 'og' => $row['og'], + 'og' => $row['brew_fermenter_sg'], 'fg' => $row['fg'], 'batch_size' => $row['batch_size'] ); @@ -603,7 +603,7 @@ } if (isset($_GET['select']) && ($_GET['select'] == "archdate")) { - $query = "SELECT record,name,code,brew_date_start,st_name,og,fg,batch_size FROM products WHERE stage = '11' ORDER BY brew_date_start;"; + $query = "SELECT record,name,code,brew_date_start,st_name,brew_fermenter_sg,fg,batch_size FROM products WHERE stage = '11' ORDER BY brew_date_start;"; $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { $brews[] = array( @@ -613,7 +613,7 @@ 'year' => substr($row['brew_date_start'], 0, 4), 'date' => substr($row['brew_date_start'], 0, 10), 'style' => $row['st_name'], - 'og' => $row['og'], + 'og' => $row['brew_fermenter_sg'], 'fg' => $row['fg'], 'batch_size' => $row['batch_size'] );