public function get_keywords($id_in_module) { $keywords = array(); $result = $this->db_querier->select('SELECT relation.id_in_module, relation.id_keyword, keyword.* FROM ' . DB_TABLE_KEYWORDS_RELATIONS . ' relation LEFT JOIN ' . DB_TABLE_KEYWORDS . ' keyword ON keyword.id = relation.id_keyword WHERE relation.module_id = :module_id AND relation.id_in_module = :id_in_module ORDER BY relation.id_keyword', array('module_id' => $this->module_id, 'id_in_module' => $id_in_module)); while ($row = $result->fetch()) { $keyword = new Keyword(); $keyword->set_properties($row); $keywords[$row['name']] = $keyword; } $result->dispose(); return $keywords; }