I need a little help. How can i send this query with codeigniter?
Delete FROM friendconnect WHERE who = 5 and whos = 1 OR whos = 5 and who = 1;
I found only that:
$this->db->where('id', $id);
$this->db->delete('mytable');
Thanks everybody!
-
it just works but not nice: $this->db->where("(whos = '$senderid' and who = '$friendid' OR who = '$senderid' and whos = '$friendid')");vihkat– vihkat2015-09-01 13:12:55 +00:00Commented Sep 1, 2015 at 13:12
-
the documentation should tell you this.: codeigniter.com/user_guide/database/…CodeGodie– CodeGodie2015-09-01 13:13:49 +00:00Commented Sep 1, 2015 at 13:13
Add a comment
|
3 Answers
$this->db->where('who', 5);
$this->db->where('whos', 1);
$this->db->or_where('whos', 5);
$this->db->where('who', 1);
$this->db->delete('friendconnect');
This is also an alternative:
$this->db->where('who', 5)->where('whos', 1)->or_where('whos', 5)->where('who', 1);
$this->db->delete('friendconnect');
This also:
$this->db->where(array('who'=>5, array('whos'=>1)))->or_where('whos', 5)->where('who', 1);
$this->db->delete('friendconnect');
More info: here
Comments
Just use this $this->db->query("Delete FROM friendconnect WHERE who = 5 and whos = 1 OR whos = 5 and who = 1");
2 Comments
vihkat
Maybe this query its not enough safety?
Rahul Patel
For safety you can use stored procedure.
$this->db->where('(who = 5 and whos = 1) OR (whos = 5 and who = 1)');
$this->db->delete('friendconnect');
