Codeigniter setting multiple where conditions, how to unset one
- by Dustin
I've got a script that is a notify_url from paypal that is supposed to update multiple tables in my database using the following code:
//update first table
$this-db-where('someid', $somid);
$this-db-update('table', $data);
///update second table
$this-db-where('somesecondid', $somesecondid)
$this-db-update('anothertable', $data2);
Then I get the following error: Unknown column 'somesecondid' in 'where clause'
UPDATE anothertable SET avail = 0 WHERE someid = '13' AND somesecondid = '199'
So codeigniter is combining those where clauses into a single query. Is there a way to unset the first one so it only has "UPDATE anothertable SET avail=0 WHERE somesecondid = 199" ? Thanks!
