please correct my code

[eluser]Fahad Alrahbi[/eluser]
hello again



can anyone correct my code

Model

Code:

function update_order($id,$old_order){
    

    //Update The order
    $query = $this->db->query("SELECT * FROM cat WHERE `cat_order`='$old_order' ");
    $row =  $query->row();
    
    $this->db->query("UPDATE cat SET cat_order='".$row->cat_order."' WHERE id='".$id."' ");
    $this->db->query("UPDATE cat SET cat_order='$old_order' WHERE id ='".$row->id."' ");
    
}

[eluser]rose_anne[/eluser]
what error message did you get.. maybe i could help you

you could also try to use the codeigniter update function http://ellislab.com/codeigniter/user-gui...tml#update