changeset
Changed order of products in production
Thu, 27 Feb 2020 16:12:07 +0100
- author
- Michiel Broek <mbroek@mbse.eu>
- date
- Thu, 27 Feb 2020 16:12:07 +0100
- changeset 611
- c583f446d6ca
- parent 610
- 38b22ccb2bf8
- child 612
- 576128de01e3
Changed order of products in production
| www/includes/db_product.php | file | annotate | diff | comparison | revisions |
--- a/www/includes/db_product.php Wed Feb 26 21:23:20 2020 +0100 +++ b/www/includes/db_product.php Thu Feb 27 16:12:07 2020 +0100 @@ -545,7 +545,7 @@ * SELECT, produce a list of products that are not yet Closed. */ if (isset($_GET['select']) && ($_GET['select'] == "inprod")) { - $query = "SELECT record,name,code,birth,stage,brew_date_start,package_date FROM products WHERE stage != '11' ORDER BY birth,code;"; + $query = "SELECT record,name,code,birth,stage,brew_date_start,package_date FROM products WHERE stage != '11' ORDER BY stage,code,birth;"; $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { $brews[] = array(
