How to get specific data from database?

[eluser]FreshProgrammer[/eluser]
Hi all..

I cannot get for example just one row record from table in database.I'm confused with using 'where' statement.I just can get all the record from database.I just wanna one row of record to be displayed.

Anyone can help me?

Here i show my code;

CONTROLLER

Code:

function search()
    {
        
        $this->load->model('Model_view');
        $data['query']=$this->Model_view->check_login($this->input->post('search'));
        $this->load->view('filter1',$data);
}

MODEL

Code:

class Model_view extends Model
{
    function Model_view()
    {
        parent::Model();
        $this->load->database();
        
    }
    
    function check_login($search)
    {    
        return $query=$this->db->get_where('tbl_staff',array('username'=>$search))->result();    
    }
}

VIEW

Code:

<?php foreach($query->result()as $row):?>
<tr>
<td>&lt;?php echo $row->name?&gt;</td>[quote][/quote]
<td>&lt;?php echo $row->username;?&gt;</td>
<td>&lt;?php echo $row->password; ?&gt;</td>
<td>&lt;?php echo $row->email;?&gt;</td>
<td>&lt;?php echo $row->position; ?&gt;</td>
<td>&lt;?php echo $row->department; ?&gt;</td>
<td>&lt;?php echo $row->campus;?&gt;</td>
</tr>
&lt;?php endforeach;?&gt;

Anyone can detect a bug?.The error always come from the view.

Thank you

[eluser]InsiteFX[/eluser]

Code:

function check_login($search)
    {    
        return $query=$this->db->limit(1)->get_where('tbl_staff',array('username'=>$search))->result();    
    }

InsiteFX