title: Codeigniter query Always returning TRUE
body: <p>I got this piece of function that updates  an account with 1 or 0,<br>
  note that the account_status has a data type of boolean.</p>
  
  <p>I understand that $this->db->query(); returns TRUE or FALSE in write queries,</p>
  
  <p>but i am having trouble, because when i tried to put a non boolean value on account_status, still the response is success, but obviously it will not update because the data is not boolean.</p>
  
  <pre><code>public function approve_account($id='0'){
          if($id == '0' OR $id== ''){
              return FALSE;
          }else{
              try{
                  $id = (int)htmlentities($id,ENT_COMPAT,'UTF-8');
                  $sql= "UPDATE elibrary.elib_user_account e 
                         SET account_status = 'hg' 
                         WHERE t_user_id = ?
                         LIMIT 1;";
  
                  if($this-&gt;db-&gt;query($sql,$id) === TRUE){
                      echo 'sucess';
                  }else{
                      echo 'FAIL';
                  }
              }catch(Exception $e){
                  echo $e;
              }
          }
      }
  </code></pre>