arrays - How to check 2 values in 1 table using PHP, jQuery? -

is there way check 2 exists values in 1 table ?

it work fine when use 1 value 'beezname' when added value 'divid' didn't work, check whether 'beezname' or 'divid' exist in table. i'm trying :

• if beezname , divid exist return true else false

how can make work? in advance

here's controller : beez

function checkbeezexists() {     $beezid = $this->input->post("beezid");      $beezname = $this->input->post("beezname");     $divid = $this->input->post("divid");      if(empty($beezid)){         $result = $this->beez_model->checkbeezexists($beezname, $divid);     } else {         $result = $this->beez_model->checkbeezexists($beezname, $divid, $beezid); }  if(empty($result)){ echo("true"); } else { echo("false"); } } 

and model : beez_model

function checkbeezexists($beezname, $divid, $beezid= 0) {     $this->db->select("beezname, divid");     $this->db->from("tbl_beez");       $this->db->where("beezname", $beezname);        $this->db->where("divid", $divid);      $this->db->where("isdeleted", 0);     if($beezid != 0){         $this->db->where("beezid !=", $beezid);       }     $query = $this->db->get();      return $query->result(); } 

you want check beezname , divid exist in model have wrong condition beezid

try below code:

function checkbeezexists($beezname, $divid, $beezid= 0) {     $this->db->select("beezname, divid");     $this->db->from("tbl_beez");       $this->db->where("beezname", $beezname);        $this->db->where("divid", $divid);      $this->db->where("isdeleted", 0);     if($beezid != 0){         $this->db->where("beezid", $beezid);  //<--------remove !=     }     $query = $this->db->get();      return $query->result(); }