Easier way to write this query CI style?

[eluser]freshface[/eluser]
Isn't there an easier (better) way to write this, CI style?

Code:

function edit($param= '')
        {
            $query = $this->db->query('SELECT a.*, b.* FROM countries AS a, test AS b WHERE b.id = ' . $param . ' AND a.iso = b.ref');
                        
            foreach ($query->result() as $row)
            {
                echo $row->iso;
                echo $row->name;
            }
            
        }

ps: when I want the values to be filled out in a view (text input) cant I do it like this:

Code:

$query->result()->iso;

or do i need to push it in an array and process each value?