Duplicate Entry DB error (any clues)?

[eluser]Hakkam[/eluser]
In your table no need add a column anyway.
You just retrieve EmplodeID and put in input type form EmployeID_orig and in input type form EmployeID. And than when you will update db, the input type EmployeID_orig as in Where condition.

<?php foreach($query->result() as $row):?>

<p>Employee ID_Origin:<br>&lt;input type='text' value=&lt;?=$row-&gt;employeeID;?&gt; name='employeeID_Origin'></p>
<p>Employee ID:<br>&lt;input type='text' value=&lt;?=$row-&gt;employeeID;?&gt; name='employeeID'></p>

And in controller :
In controller :

function update_emp()
{
$this->load->database();

$this->db->set(‘employeeID’,$_POST[‘employeeID’]);
$this->db->where(‘employeeID’,$_POST[‘employeeID_Origin’]);
$this->db->update(‘tblemployee’);