diff -r 7f41b61c3faf -r 601920b902e5 www/includes/db_recipes.php --- 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;