Good day
I’m trying to add a friend request functionality but this statement can’t work .
public function cancel_or_ignore_friend_request($data){
$this->db->query('DELETE FROM friend_request WHERE (sender = :my_id AND receiver = :frnd_id) OR (sender = :frnd_id AND receiver = :my_id)');
$this->db->bind(':my_id', $data['my_id']);
$this->db->bind(':frnd_id', $data['user_id']);
if($this->db->execute()){
return true;
}else {
return false;
}
}
it’s just not working, Here am trying to create ignor or cancel friend request.
Please help
Thanks in advance
if more code is needed please let me know