comparison: www/includes/db_product.php
www/includes/db_product.php
- changeset 611
- c583f446d6ca
- parent 602
- 10b61aacb1c1
- child 615
- 9034e65b0d7a
equal
deleted
inserted
replaced
| 610:38b22ccb2bf8 | 611:c583f446d6ca |
|---|---|
| 543 } else { | 543 } else { |
| 544 /* | 544 /* |
| 545 * SELECT, produce a list of products that are not yet Closed. | 545 * SELECT, produce a list of products that are not yet Closed. |
| 546 */ | 546 */ |
| 547 if (isset($_GET['select']) && ($_GET['select'] == "inprod")) { | 547 if (isset($_GET['select']) && ($_GET['select'] == "inprod")) { |
| 548 $query = "SELECT record,name,code,birth,stage,brew_date_start,package_date FROM products WHERE stage != '11' ORDER BY birth,code;"; | 548 $query = "SELECT record,name,code,birth,stage,brew_date_start,package_date FROM products WHERE stage != '11' ORDER BY stage,code,birth;"; |
| 549 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); | 549 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); |
| 550 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { | 550 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { |
| 551 $brews[] = array( | 551 $brews[] = array( |
| 552 'record' => $row['record'], | 552 'record' => $row['record'], |
| 553 'name' => $row['name'], | 553 'name' => $row['name'], |
