www/includes/db_inventory_yeasts.php

changeset 37
9362eb9e9e5b
parent 33
2ee6ad5d6f14
child 77
a9f8de2d7b2b
--- a/www/includes/db_inventory_yeasts.php	Sat Aug 25 11:40:31 2018 +0200
+++ b/www/includes/db_inventory_yeasts.php	Sat Aug 25 13:07:13 2018 +0200
@@ -10,7 +10,7 @@
 }
 
 // get data and store in a json array
-$query = "SELECT * FROM inventory_yeasts";
+$query = "SELECT * FROM inventory_yeasts ORDER BY laboratory,product_id,name";
 if (isset($_GET['insert'])) {
 	// INSERT COMMAND
 	$sql  = "INSERT INTO `inventory_yeasts` SET name='" . mysqli_real_escape_string($connect, $_GET['name']);

mercurial