Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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."' ");
- }
- $sql = "UPDATE table SET column = ? WHERE id = ?";
- $this->db->query($sql, array($value, $id));
- $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 );
- $this->db->where('id',$id);
- $this->db->set('cat_order',$row->cat_order);
- $this->db->update('cat');
Add Comment
Please, Sign In to add comment