mysql - update of same id in two tables at a time in sql -

mysql - update of same id in two tables at a time in sql -

how update id , name @ time in 2 different tables if update changing id in 1 table not updating in table.as copied controller,and view. total code can help me how update @ time in 2 tables. model:

function updatecategory($cat_sub_cat_id) { $this->db->trans_start(); $data=array( 'cat_id'=>$this->input->post('cat_id'), 'name'=>$this->input->post('mainc') ); $this->db->where('cat_id',$cat_sub_cat_id); $this->db->update('category',$data); $data=array( 'cat_id'=>$this->input->post('cat_id') ); $this->db->where('cat_sub_cat_id',$cat_sub_cat_id); $this->db->update('category_subcategory_association',$data); $this->db->trans_complete(); }

controller:

function editcategory() { $this->load->library('form_validation'); $this->form_validation->set_error_delimiters('<br /><span class="error"> ','</span>'); $this->form_validation->set_rules('cat_id','category id','required'); $this->form_validation->set_rules('name','name','required'); if($this->form_validation->run()==false) { $data['records']= $this->bulkupload_model->get_category($this->input->post('cat_sub_cat_id')); $data['mode'] = "edit"; $data['mainpage'] = "category"; $this->load->view('includes/mainpage', $data); } else { $this->bulkupload_model ->updatecategory($this->input->post('cat_sub_cat_id')); if(is_array($result)): $data['records']=$this->bulkupload_model->get_category($this->uri->segment('cat_sub_cat_id')); $data['errors']=$result; $data['mainpage']='category'; $data['mode']='edit'; $this->load->view('includes/mainpage',$data); else: $this->flash->success('successfully updated record.'); redirect('uploads/index'); endif; } }

view:

<form id="validation" class="form-horizontal" action="<?php echo base_url();?>uploads/editcategory" method="post"> <?php echo form_hidden('cat_sub_cat_id',$record->cat_sub_cat_id);?> <div class="row-form clearfix"> <div class="span3"><label for="cat_id">category id</label></div> <div class="span9"><input class="validate[required]" type="text" id="cat_id" name="cat_id" value="<?php echo $record->cat_id;?>"/></div> </div> <div class="row-form clearfix"> <div class="span3"> <label for="name">category name</label> </div> <div class="span9"><input class="validate[required]" type="text" id="name" name="name" value="<?php echo $record->mainc;?>"/></div> </div>

could have typo on here ?

$this->bulkupload_model ->updatecategory($this->input->post('cat_sub_cat_id')); //---------------------^

should like

$this->bulkupload_model->updatecategory($this->input->post('cat_sub_cat_id'));

mysql codeigniter