--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/www/getwatersources.php	Thu Sep 06 14:22:02 2018 +0200
@@ -0,0 +1,27 @@
+<?php
+require_once('config.php');
+
+$query = "SELECT * FROM inventory_waters ORDER BY name";
+$connect = mysqli_connect(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME);
+if (! $connect) {
+	echo "[]";
+	return;
+}
+$result = mysqli_query($connect, $query);
+while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
+	$waters[] = array(
+		'record' => $row['record'],
+		'name' => $row['name'],
+		'unlimited_stock' => $row['unlimited_stock'],
+		'calcium' => $row['calcium'],
+		'sulfate' => $row['sulfate'],
+		'chloride' => $row['chloride'],
+		'sodium' => $row['sodium'],
+		'magnesium' => $row['magnesium'],
+		'ph' => $row['ph'],
+		'total_alkalinity' => $row['total_alkalinity'],
+		'default_water' => $row['default_water'],
+		'cost' => $row['cost']
+	);
+}
+echo json_encode($waters);