www/includes/db_inventory_water_sources.php

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

mercurial