problem with update table

[eluser]pam81[/eluser]
hi, i'm trying to update two rows in this way

$this->db->where("id",1); $this->db->update("movil",array("ordenbase"=>$nuevoorden));

$this->db->where("id",2);
$this->db->update("movil",array("ordenbase"=>$orden));

but it's not working. Once it update row=1 and other time it update row=2 but it's like a random behauvior.

[eluser]allaerd[/eluser]
did you try $this->db->affected_rows() to see if it actually does update?

[eluser]danmontgomery[/eluser]
Enable profiler to see what queries are being run?

Code:

$this->output->enable_profiler();