mysql_fetch_assoc in CI

[eluser]xwero[/eluser]

Code:

$query = $this->db->query("SELECT pool_id
                  FROM pool_question
                  WHERE active = 1
                  ORDER BY question_id DESC
                  LIMIT 1");

$row = $query->row_array();

$maxID = $row['pool_id'];