Mercurial > bms / file diff

--- a/www/includes/db_recipes.php	Sat Dec 08 15:01:23 2018 +0100
+++ b/www/includes/db_recipes.php	Sat Dec 08 15:20:03 2018 +0100
@@ -16,8 +16,6 @@
 $rreplacements = array("\\'");
 $disallowed = array('visibleindex','uniqueid','boundindex','uid');
 
-// get data and store in a json array
-$query = "SELECT * FROM recipes ORDER BY st_guide,st_letter,st_name,name";
 if (isset($_POST['insert']) || isset($_POST['update'])) {
 	if (isset($_POST['insert'])) {
 		// INSERT COMMAND
@@ -164,7 +162,14 @@
 	echo $result;
 
 } else {
-	// SELECT COMMAND
+	/*
+	 * Select all or a given record.
+	 */
+	if (isset($_GET['record'])) {
+		$query = "SELECT * FROM recipes WHERE record='" . $_GET['record'] . "';";
+	} else {
+		$query = "SELECT * FROM recipes ORDER BY st_guide,st_letter,st_name,name";
+	}
 	$result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect));
 	$recipes = '[';
 	$comma = FALSE;