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');


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2021 MyBB Group.