summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorNathan Kinkade <nath@nkinka.de>2017-10-02 21:48:27 +0000
committerNathan Kinkade <nath@nkinka.de>2017-10-02 21:48:27 +0000
commit5e3713a48f4695013432cb16367a936e108a4e51 (patch)
tree505e51fc2814139780731d76bfebb2711bed6a10
parentd38f46f6b5b77910da8a630749a001e5a64c82fa (diff)
Only returns foods that are active in current database.dev
-rw-r--r--food_search.php1
1 files changed, 1 insertions, 0 deletions
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
);