Syntax in function does not work

You have called the row() method wrong, try this:

PHP Code:

function test() {
  $test = $this->db->query("SELECT name FROM users");
  $name = $test->row()->name;
  return $name;
}