dynamic form_dropdown()

[eluser]selftaught[/eluser]
I have been trying to figure out how to populate a form_dropdown using the form helper but have had no luck.

Below are the pieces to my project. Any help is greatly appreciated.

controller

Code:

<?php

class Site extends CI_Controller {
    
    function contact_us()
    {
        $data['main_content'] = 'contact_us';
        $this->load->view('template',$data);
    }
    
    function about_us()
    {
        $data['main_content'] = 'about_us';
        $this->load->view('template',$data);        
    }
        
    function trx_form()
    {
        $data['main_content'] = 'trx_form';
        $this->load->view('template',$data);
        
        $this->load->model('trx_model');
        
        $data['query'] = $this->trx_model->get_markets();
        $this->load->view('trx_form',$data);
    }
}

model

Code:

<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');

class trx_model extends CI_Model {

        function __construct()
        {
                // Call the Model constructor
                parent::__construct();
        }
        
        function get_markets()
        {
            $sql = "SELECT DISTINCT AASwitch FROM audit.btseqp";
            $query = $this->db->query($sql);
            return $query->result();
        }
}

view

Code:

<?php foreach($query as $market)
{
    echo form_dropdown('shirts', $market, 'large');
}
?>

The menu is being created but each element is in its own select box.
Also below are the errors I am getting from PHP.
A PHP Error was encountered
Severity: Notice

Message: Undefined variable: query

Filename: views/trx_form.php

Line Number: 1

A PHP Error was encountered
Severity: Warning

Message: Invalid argument supplied for foreach()

Filename: views/trx_form.php

Line Number: 1