Having problems with creating a CRUD..

[eluser]ealonw[/eluser]
Much progress!! thank you guys so much... one problem left though.. whn click the EDIT link it repopulates the form with only the first row of the database and not the row I select... strange... here's updated the code..
*****************************************
function update($id=NULL)
{
$this->load->helper('form');
// $id = $this->uri->segment(2);
$query = $this->db->getwhere('myname', array('id', $id));


$data['name'] = $query->row();

if ( count($_POST) > 0 )
{
$this->db->where('name', $name);
$this->db->update('myname', $_POST);
redirect('');
}
else
{
$this->load->view('update_name_view', $data);
}
}
}
************************************************************
<?= form_open('name/update/'.$name->id); ?>
First Name
<input type="text" name="name" maxlength="20" value="<?=$name->name?>">
<br><br>
&lt;input type="submit" name="submit" value="submit"&gt;
&lt;/form&gt;
&lt;?=form_close()?&gt;