diff options
| author | Nathan Kinkade <nath@nkinka.de> | 2017-10-02 21:49:47 +0000 |
|---|---|---|
| committer | Nathan Kinkade <nath@nkinka.de> | 2017-10-02 21:49:47 +0000 |
| commit | 87fbf79db1b566e5b44a2fbf751d36861b05b844 (patch) | |
| tree | a4335cc3aea8d9a148f5848f5f2b0442b6427afa | |
| parent | 8c5859eea96b9bb9b7fe638dde829b1c58c0a5a0 (diff) | |
Only returns foods that are active in current database.
| -rw-r--r-- | food_search.php | 1 |
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 ); |
