# HG changeset patch # User Michiel Broek # Date 1552042803 -3600 # Node ID bf5fa5277c9fb2ed51a6e31957c721687eb2244e # Parent 9a8c650972caa4deae4389387d08936402e4b876 Allow to select beer that is in carbonation stage diff -r 9a8c650972ca -r bf5fa5277c9f www/includes/db_product.php --- a/www/includes/db_product.php Fri Mar 08 11:31:06 2019 +0100 +++ b/www/includes/db_product.php Fri Mar 08 12:00:03 2019 +0100 @@ -505,7 +505,7 @@ */ if (isset($_GET['select']) && ($_GET['select'] == "ferment")) { $query = "SELECT code,name,uuid,stage,json_yeasts FROM products WHERE "; - $query .= "stage='1' OR stage='2' OR stage='3' OR stage='4' OR stage='5' OR stage='6' ORDER BY code;"; + $query .= "stage='1' OR stage='2' OR stage='3' OR stage='4' OR stage='5' OR stage='6' OR stage='7' ORDER BY code;"; $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { $yl = 0;