[SOLVED] delete row

[eluser]maria clara[/eluser]
here is my controller (it is in switch but i will just show you the delete case):

Code:

function detailpost()
    {

        $crudColumns =  array(
            'id'=>'company_id'
            ,'company_code'=>'company_code'
            ,'company_name'=>'company_name'
        );
        $crudTableName = 'erp_maint_company';
        $postConfig['id'] = 'company_id';

        
        $postConfig['action'] = 'oper';             /* action variable */
    keyword *//* set to be the same as action keyword for default */
        $crudConfig['create'] = 'add';                /* action CREATE keyword */
        $crudConfig['update'] = 'edit';                /* action UPDATE keyword */
        $crudConfig['delete'] = 'del';                /* action DELETE keyword */
        $crudConfig['totalPages'] = 'total';        /* total pages */
        $crudConfig['totalRecords'] = 'records';    /* total records */
        

foreach ($postConfig as $key => $value){
            if(isset($_REQUEST[$value])){
                $postConfig[$key] = fnCleanInputVar($_REQUEST[$value]);
            }

/*some other case statement here*/

case $crudConfig['delete']:
                #print_r($_POST);
                $this->db->where('company_id', $this->input->post('id'));
                $this->User->delete($crudTableName);
                //$this->db->delete($crudTableName);
            }

here's my model (will show you just the function concerning the delete)

Code:

function delete($data) //Query function use to delete user
    {
        
        $deleted_row = $data['company_code'];
        
        //$data['is_deleted'] = '1';
        $this->db->where('company_id', $data['company_id']);
        $this->db->update('maint_company', $data);  //<------ even if i use the set in replace of update
    
        $this->db->where('user_id', $data['user_id']);
        $this->db->update('sec_companyaccess', $data); //<------ even if i use the set in replace of update
        
        return $deleted_row;
        
    }