diff -r 4b829f689d7e -r 9362eb9e9e5b www/includes/db_inventory_yeasts.php --- 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']);