/** * Private function to load a MCL Concept List definition object. */ private function _loadConceptListDefinition($id) { // Load the concept list definition $sql_list = 'select cl.concept_list_id, cl.list_name, cd.dict_id, cd.dict_name, cd.db_name ' . 'from mcl.concept_list cl ' . 'left join mcl.concept_dict cd on cd.dict_id = cl.dict_id ' . 'where cl.concept_list_id = ' . $id; $rsc_list = mysql_query($sql_list, $this->getConnection()); if (!$rsc_list) { echo "could not query db in ConceptListFactory::_loadConceptListDefinition: " . mysql_error(); exit; } // Create the ConceptListDefinition object $cld = null; if ($row = mysql_fetch_assoc($rsc_list)) { $cld = new ConceptListDefinition(); $cld->setListId($row['concept_list_id']); $cld->setName($row['list_name']); $cld->setDescription(''); $cld->setDictionary($row['dict_id'], $row['dict_name'], $row['db_name']); } return $cld; }