CODEWITHSUNDEEP
mysqlcodeigniterwhere-clause
Dustin
Dustin

Reputation: 11

Codeigniter setting multiple where conditions, how to unset one

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!

Upvotes: 0

Views: 5706

Answers (2)

Nickro
Nickro

Reputation: 31

You might want to look into Active Record Caching in the user_guide...
http://codeigniter.com/user_guide/database/active_record.html#caching
Maybe you have '$this->db->start_cache()' somewhere earlier in your code.

Upvotes: 2

Colin Brock
Colin Brock

Reputation: 21575

Currently, I'm unable to replicate your error. I'm successfully running two update statements as you have them above.

As an alternative, you can pass the WHERE clause information directly to $this->db->update() using an array (per the CodeIgniter Active Record documentation) like this:

$this->db->update('table', $data, array('someid' => $someid));
$this->db->update('anothertable', $data2, array('somesecondid' => $somesecondid));

Upvotes: 1

Related Questions