[eluser]mddd[/eluser]
No problem Smilie. It often happens that one discussion leads into the next.
Allright. The question is: which do you mean for the 'id=action_id' part. Because that is the ambigious thing here.
Remember, CI doesn't know if a value is a column or a string. By default it will think that the first variable is the column name and the second is a value you want to test against. So if you write
Code:
$this->db->where('id', 'action_id');
you get:
Code:
WHERE `id` = 'action_id'
That's logical. The column name is marked with backticks by CI and the value is simple a string: "action_id".
If you would write
Code:
$this->db->where('id','action_id',false);
you get:
Code:
WHERE id = 'action_id'
That's because you tell CI not to put in the backticks for the column name.
But still, CI will think of the second parameter as a value, not a column name. So you must write
Code:
$this->db->where('id = action_id','',false)
Then you get:
Code:
WHERE id = action_id
There are no backticks because you told CI not to use them. Your argument is copied just as you wrote it.
And you leave the second parameter empty so CI doesn't write '=....' somewhere.