Welcome Guest, Not a member yet? Register   Sign In
One basic db where question
#1

[eluser]luffy[/eluser]
How to use active record to implement the function:

DELETE FROM `dt_crazy` WHERE `id` = '53' AND (`from_id` = '2' OR `to_id` = '2')


$this->db->where('id', $id);
$this->db->where('from_id', 2);
$this->db->or_where('to_id', 2);
$this->db->delete('dt_crazy');
#2

[eluser]JHackamack[/eluser]
$this->db->where('id',$id);
$this->db->where('(from_id = "2" or to_id = "2")');
$this->db->delete('dt_crazy');




Theme © iAndrew 2016 - Forum software by © MyBB