From 87fbf79db1b566e5b44a2fbf751d36861b05b844 Mon Sep 17 00:00:00 2001 From: Nathan Kinkade Date: Mon, 2 Oct 2017 21:49:47 +0000 Subject: Only returns foods that are active in current database. --- food_search.php | 1 + 1 file changed, 1 insertion(+) diff --git a/food_search.php b/food_search.php index 4e92c74..f77e836 100644 --- a/food_search.php +++ b/food_search.php @@ -121,6 +121,7 @@ $sql = sprintf (" FROM foodDescs LEFT JOIN foodCats ON foodDescs.fdgrp_cd = foodCats.fdgrp_cd %s + AND foodDescs.usda_status = 'active' ", $where ); -- cgit v1.2.3