diff options
| author | Nathan Kinkade <nath@nkinka.de> | 2017-10-02 21:48:27 +0000 |
|---|---|---|
| committer | Nathan Kinkade <nath@nkinka.de> | 2017-10-02 21:48:27 +0000 |
| commit | 5e3713a48f4695013432cb16367a936e108a4e51 (patch) | |
| tree | 505e51fc2814139780731d76bfebb2711bed6a10 | |
| parent | d38f46f6b5b77910da8a630749a001e5a64c82fa (diff) | |
Only returns foods that are active in current database.dev
| -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 ); |
