www/prod_beerxml.php

changeset 606
39d4b9e7b447
parent 605
538627a5555c
child 667
1246550451ca
--- a/www/prod_beerxml.php	Thu Jan 30 15:29:43 2020 +0100
+++ b/www/prod_beerxml.php	Thu Jan 30 15:44:00 2020 +0100
@@ -18,7 +18,7 @@
 if (isset($_GET["record"]))
 	$record = $_GET["record"];
 else
-	$record = 78;
+	$record = 71;
 $result = mysqli_query($link, "SELECT * FROM products WHERE record='".$record."'");
 $row = mysqli_fetch_array($result);
 
@@ -251,7 +251,7 @@
 xmlwriter_start_element($xw, 'WATERS');
 xmlwriter_start_element($xw, 'WATER');	// Source 1
 field($xw, 'VERSION', '1');
-field($xw, 'NAME', $item['w1_name']);
+field($xw, 'NAME', $row['w1_name']);
 field($xw, 'AMOUNT', sprintf("%.2f",floatval($row['w1_amount'])));
 field($xw, 'CALCIUM', sprintf("%.2f",floatval($row['w1_calcium'])));
 field($xw, 'MAGNESIUM', sprintf("%.2f",floatval($row['w1_magnesium'])));
@@ -266,7 +266,7 @@
 if (strlen($row['w2_name'])) {
 	xmlwriter_start_element($xw, 'WATER');	// Source 2
 	field($xw, 'VERSION', '1');
-	field($xw, 'NAME', $item['w2_name']);
+	field($xw, 'NAME', $row['w2_name']);
 	field($xw, 'AMOUNT', sprintf("%.2f",floatval($row['w2_amount'])));
 	field($xw, 'CALCIUM', sprintf("%.2f",floatval($row['w2_calcium'])));
 	field($xw, 'MAGNESIUM', sprintf("%.2f",floatval($row['w2_magnesium'])));
@@ -282,7 +282,7 @@
 
 xmlwriter_start_element($xw, 'MASH');
 field($xw, 'VERSION', '1');
-field($xw, 'NAME', $item['mash_name']);
+field($xw, 'NAME', $row['mash_name']);
 field($xw, 'GRAIN_TEMP', '10.0');
 field($xw, 'PH', sprintf("%.1f",floatval($row['sparge_ph'])));
 field($xw, 'SPARGE_TEMP', sprintf("%.1f",floatval($row['sparge_temp'])));

mercurial