www/includes/db_inventory_fermentables.php

changeset 37
9362eb9e9e5b
parent 18
395833e20f88
child 39
400aae9fb0c8
--- a/www/includes/db_inventory_fermentables.php	Sat Aug 25 11:40:31 2018 +0200
+++ b/www/includes/db_inventory_fermentables.php	Sat Aug 25 13:07:13 2018 +0200
@@ -11,7 +11,7 @@
 }
 
 // get data and store in a json array
-$query = "SELECT * FROM inventory_fermentables";
+$query = "SELECT * FROM inventory_fermentables ORDER BY supplier,name";
 if (isset($_GET['insert'])) {
 	// INSERT COMMAND
 	$sql  = "INSERT INTO `inventory_fermentables` SET name='" . mysqli_real_escape_string($connect, $_GET['name']);

mercurial