comparison: www/includes/db_product.php
www/includes/db_product.php
- changeset 326
- bf5fa5277c9f
- parent 321
- 4116e6184609
- child 332
- f0ca77097236
equal
deleted
inserted
replaced
| 325:9a8c650972ca | 326:bf5fa5277c9f |
|---|---|
| 503 /* | 503 /* |
| 504 * SELECT, produce a list of products that can be fermented. | 504 * SELECT, produce a list of products that can be fermented. |
| 505 */ | 505 */ |
| 506 if (isset($_GET['select']) && ($_GET['select'] == "ferment")) { | 506 if (isset($_GET['select']) && ($_GET['select'] == "ferment")) { |
| 507 $query = "SELECT code,name,uuid,stage,json_yeasts FROM products WHERE "; | 507 $query = "SELECT code,name,uuid,stage,json_yeasts FROM products WHERE "; |
| 508 $query .= "stage='1' OR stage='2' OR stage='3' OR stage='4' OR stage='5' OR stage='6' ORDER BY code;"; | 508 $query .= "stage='1' OR stage='2' OR stage='3' OR stage='4' OR stage='5' OR stage='6' OR stage='7' ORDER BY code;"; |
| 509 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); | 509 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); |
| 510 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { | 510 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { |
| 511 $yl = 0; | 511 $yl = 0; |
| 512 $yh = 40; | 512 $yh = 40; |
| 513 $yeasts = json_decode($row['json_yeasts'], true); | 513 $yeasts = json_decode($row['json_yeasts'], true); |
