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