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