www/includes/db_product.php

changeset 192
7f69b43e6084
parent 185
4c25db9e8102
child 235
0a063ac5d7f5
--- a/www/includes/db_product.php	Sat Jan 19 13:58:24 2019 +0100
+++ b/www/includes/db_product.php	Sat Jan 19 17:31:43 2019 +0100
@@ -338,13 +338,14 @@
 	 * SELECT, produce a list of products that can be fermented.
 	 */
 	if (isset($_GET['select']) && ($_GET['select'] == "ferment")) {
-		$query  = "SELECT code,name,stage FROM products WHERE ";
+		$query  = "SELECT code,name,uuid,stage FROM products WHERE ";
 		$query .= "stage='Wait' OR stage='Brew' OR stage='Primary' OR stage='Secondary' OR stage='Tertiary' OR stage='Carbonation' ORDER BY code;";
 		$result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect));
 		while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
 			$brews[] = array(
 				'code' => $row['code'],
 				'name' => $row['name'],
+				'uuid' => $row['uuid'],
 				'stage' => $row['stage']
 			);
 		}

mercurial