Welcome Guest, Not a member yet? Register   Sign In
Deleting data with query binding
#1

[eluser]rajend3[/eluser]
Hi,

I'm trying to delete data from a table but the data remains after running the delete method in the model. Any ideas as to where I went wrong?

Thanks

Code:
public function remove_partner($uid, $partnerId)
{
  $sql = "DELETE FROM partners WHERE user_id = ? AND partner_id = ?";
  
  if ($this->db->query($sql, array($uid, $partnerId)))
  {
   return TRUE;
  }
  else
  {
   return null;
  }
}

Code:
if ($this->session->userdata("uid"))
  {
   $this->load->model("partner_model");
   if (!$this->partner_model->remove_partner($this->session->userdata("uid"), $this->uri->segment(2)))
   {
    $data["errorMessage"] = "Could not remove partner, please contact support.";
   }
  
   redirect("partner_controller/members");
  }




Theme © iAndrew 2016 - Forum software by © MyBB