Remove dependence on ADOdb and use PHP PDO instead.

1 files changed, 2 insertions, 2 deletions

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);