summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorNathan Kinkade <nath@nkinka.de>2017-10-02 21:49:47 +0000
committerNathan Kinkade <nath@nkinka.de>2017-10-02 21:49:47 +0000
commit87fbf79db1b566e5b44a2fbf751d36861b05b844 (patch)
treea4335cc3aea8d9a148f5848f5f2b0442b6427afa
parent8c5859eea96b9bb9b7fe638dde829b1c58c0a5a0 (diff)
Only returns foods that are active in current database.
-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
);