[SOLVED] delete row

[eluser]maria clara[/eluser]
when i have the

Code:

$this->db->where('user_id', $data['user_id']);

in my MODEL delete function i got this message from my console

DELETE FROM `erp_maint_company`
WHERE `company_id` = '47'
AND `company_id` = '47'

<h4>A PHP Error was encountered</h4>

<p>Severity: Notice</p>
<p>Message: Undefined index: user_id</p> <-------- user_id shows undefined
<p>Filename: models/users_db.php</p>
<p>Line Number: 307</p>

</div>DELETE FROM `erp_sec_companyaccess`
WHERE `user_id` IS NULL <---------- and it is NULL
AND `company_id` = '47'
AND `company_id` = '47'{"company_id":"47"}

maybe because im trying to delete the company_id only from the maint_company and sec_companyaccess table.

but when i commented the

Code:

//$this->db->where('user_id', $data['user_id']);

it shows me no undefined index for user_id. but when i click the refresh button in the jqgrid, the one i deleted shows up again and the records becomes 10 again instead of 9. i have 10 records.

EDIT:

DELETE FROM `erp_maint_company`
WHERE `company_id` = '48'
AND `company_id` = '48'DELETE FROM `erp_sec_companyaccess`
WHERE `company_id` = '48'
AND `company_id` = '48'{"company_id":"48"}

in this, it shows that it is deleted but actually it is not. it will be just deleted if i will delete it straight in the table where it is located.

i attached images for you to see.