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. --- food_quantity.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'food_quantity.php') diff --git a/food_quantity.php b/food_quantity.php index b938745..e93c17e 100644 --- a/food_quantity.php +++ b/food_quantity.php @@ -25,13 +25,13 @@ if ( isset($_REQUEST['food']) ) { # get the selected food and quantities from the database $sql = sprintf (" - SELECT foodDescs.sciname, %s AS foodDesc, weights.* + SELECT foodDescs.sciname, CONCAT(foodDescs.long_desc, foodDescs.comname) + AS foodDesc, weights.* FROM foodDescs LEFT JOIN weights ON foodDescs.ndb_no = weights.ndb_no WHERE foodDescs.ndb_no = '%s' AND weights.usda_status = 'active' ", - $db->_dbConn->Concat("foodDescs.long_desc", "', '", "foodDescs.comname"), $food ); $db->Select($sql); -- cgit v1.2.3