CodeIgniter get_where

[eluser]n0xie[/eluser]
[quote author="Hanabi" date="1255710455"]Hey noxie,

My controller now includes;
[/quote]
Aah I read too fast, I was under the assumption you were using a model. Since you are calling the database directly from the controller you don't need to return the data.

[quote author="Hanabi" date="1255710455"]

Code:

function files()
{
    $this->load->view('account/files');        
    $owner = $this->auth->get_user();        
    return $this->db->get_where('files', array('owner =' => '$owner'))->result();        
}

[/quote]

Where do you call your view? If your view is 'account/files' change it to this:

Code:

// controller
    $owner = $this->auth->get_user();      
    // we store the output of the query into a data array
    $data['files'] = $this->db->get_where('files', array('owner =' => '$owner'))->result();  
    // we pass the data array to the view
    $this->load->view('account/files',$data);  

// view
    
    // we passed the data array to the view which now gives us access to 'files' where
    // our query result is stored
    <?php foreach($files as $file): ?>

    <div class="section">
        <span>&lt;?=$file->file_name?&gt;</span>    
    </div>

    &lt;?php endforeach; ?&gt;