DropDownlist - no data loading

[eluser]penta997[/eluser]
helo. I have a problem with drop down list. When I running a page, data don't displaying in web browser.
This is model code:

Code:

function get_Country()
      {
           $query = $this->db->query('Select * from country');

                
           return $query;
          
       }

Controller function:

Code:

function register()
       {
            $widok['left'] = $this->get_category();
            $widok['right'] = $this->load->view('Ksiegarnia/right', '', true);

             $this->load->model('Users_model');
             $data['data'] = $this->Users_model->get_Country();


            
          
            $widok['center'] = $this->load->view('Ksiegarnia/register_view', $data, true);

            $this->load->view('Ksiegarnia/index', $widok);
       }

register_view View:

Code:

<div class="form">
<h1>Registration<h1>
&lt;?php echo form_open('ksiegarnia/validation');?&gt;
&lt;!-- user --&gt;
<p>Login: &lt;?php echo form_input('username', '');?&gt;</p>
<p>Password: &lt;?php echo form_password('pass', '');?&gt;</p>
<p>Confirm password: &lt;?php echo form_password('pass2', '');?&gt;</p>


&lt;?php

echo '<select name="country">';
foreach($data->result() as $item)
{
    echo '<option value = "'.$item->COUNTRY_Id.'">'.$item->COUNTRY_Name.'</option>';
}
echo '</select>';

?&gt;

&lt;?php echo form_submit('wyslij', 'Wyślij');?&gt;
&lt;?php echo anchor('ksiegarnia/register', 'Zarejestruj');?&gt;
&lt;?php echo form_close(); ?&gt;
</div>

[eluser]Cristian Gilè[/eluser]
Try to comment out the call to the model and check if it works.
Is country the right name for the table? Not Country or COUNTRY?

Cristian Gilè

[eluser]penta997[/eluser]
I've changed controller:

Code:

function register()
       {
            $widok['left'] = $this->get_category();
            $widok['right'] = $this->load->view('Ksiegarnia/right', '', true);

             //$this->load->model('Users_model');
             //$data['data'] = $this->Users_model->get_Country();


            
          
            $widok['center'] = $this->load->view('Ksiegarnia/register_view', '', true);

            $this->load->view('Ksiegarnia/index', $widok);
       }

and view:

Code:

<?php
$option = array('one' => 'item1', 'two'=>'item2');
echo "<select name='country'>";


foreach($option as $item):

    echo "<option value = '$item'>".$item."</option>";
endforeach;
echo "</select>";

?&gt;

And it works.
The name COUNTRY_Name is correct.

[eluser]penta997[/eluser]
I was fixed it. It works.