DB Active Record Class WHERE question

[eluser]gtech[/eluser]
the easiest option I can think of

Code:

$sql = "SELECT * FROM qanda
WHERE status = ? AND shortcourse = ? AND  (question LIKE ? OR  answer LIKE ?)
ORDER BY schoolyear DESC, shortcourse DESC, archivename DESC, createdate ASC, createtime ASC ";

$this->db->query($sql, array($this->parameters['status'],
                             $this->parameters['shortcourse'],
                             $this->parameters['keyword'],
                             $this->parameters['keyword']));