From 37181c4e7811eedaf47161ec8533052fdac18d89 Mon Sep 17 00:00:00 2001 From: Nathan Kinkade Date: Wed, 1 Jul 2015 02:28:16 +0000 Subject: Remove dependence on ADOdb and use PHP PDO instead. --- nutrient_search.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'nutrient_search.php') diff --git a/nutrient_search.php b/nutrient_search.php index 21531b4..64ddb2d 100644 --- a/nutrient_search.php +++ b/nutrient_search.php @@ -38,7 +38,8 @@ $smarty->assign("count", $_GET['count']); # execute query $sql = sprintf (" - SELECT foodDescs.ndb_no, foodDescs.long_desc, foodDescs.comname, %s AS foodDesc, + SELECT foodDescs.ndb_no, foodDescs.long_desc, foodDescs.comname, + CONCAT(foodDescs.long_desc, foodDescs.comname) AS foodDesc, nutrientData.nutr_val, nutrientDefs.nutrdesc, nutrientDefs.units FROM foodDescs LEFT JOIN nutrientData ON foodDescs.ndb_no = nutrientData.ndb_no @@ -47,7 +48,6 @@ $sql = sprintf (" WHERE nutrientDefs.nutr_no = '%s' ORDER BY nutrientData.nutr_val DESC ", - $db->_dbConn->Concat("foodDescs.long_desc", "', '", "foodDescs.comname"), $_GET['nutrient'] ); -- cgit v1.2.3