line 125 seems to have a problem. i think it should be:

PHP Code:
$result2 = $db->Execute ( "SELECT products_name FROM " . TABLE_PRODUCTS_DESCRIPTION . " WHERE products_id = " . $result->fields[products_id] . " LIMIT 1"); 
i suppose you could cast it to integer as well.... but $products_id is not defined.

not sure about getting a language either... as the name could be in a random language if one has multiple languages on the site.