[SOLVED] delete row

[eluser]maria clara[/eluser]
[quote author="theprodigy" date="1266487932"]show me your model code please[/quote]

here is my model

Code:

function delete($data) //Query function use to delete detail user
    {
        #$deleted_row = $data['company_code'];
        
        //$data['maint_company.is_deleted'] = '1';
        $this->db->where('company_id', $data['company_id']);
        $this->db->update('maint_company',$data); // need to DELETE, not UPDATE
        //echo $this->db->last_query(); //<----- put this here  
        //$this->db->where('user_id', $data['user_id']);
        //$this->db->where('company_id', $data['company_id']); //need this field too or will delete ALL the companies associated with the user
        $this->db->update('sec_companyaccess', $data); // need to DELETE, not UPDATE
        echo $this->db->last_query(); //<----- put this here  
        #return $deleted_row;
    }

controller

Code:

case $crudConfig['delete']:  // kaht code -deleting but have error
                //$data['table_name'] = $crudTableName;
                $data['company_id'] = $this->input->post('id'); // and make sure are posting this data
                //$data['user_id'] = $this->input->post('user_id'); // and make sure are posting this data
                $this->User->delete($data); //<----- need to pass the company data, the user id, and the table name to the query

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