[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><?php echo $row->name?></td>[quote][/quote]
<td><?php echo $row->username;?></td>
<td><?php echo $row->password; ?></td>
<td><?php echo $row->email;?></td>
<td><?php echo $row->position; ?></td>
<td><?php echo $row->department; ?></td>
<td><?php echo $row->campus;?></td>
</tr>
<?php endforeach;?>
Anyone can detect a bug?.The error always come from the view.
Thank you