Codeigniter select query with AND and OR condition

by

You can code it like this:

       $this->db->where('wrk_fld_exc',140);
       $this->db->where('wrk_cs_sts','open');
       $where="(wrk_dlvrd_sts="open" or wrk_cl_sts = "Success")";
       $this->db->where($where);

More Related Contents:

  1. CodeIgniter Disallowed Key Characters
  2. subquery in codeigniter active record
  3. Does CodeIgniter automatically prevent SQL injection?
  4. Convert string to ObjectID in MongoDB
  5. Codeigniter – no input file specified
  6. codeigniter CSRF error: “The action you have requested is not allowed.”
  7. Codeigniter image resize?
  8. Removing specific items from array with MongoDB
  9. How to rewrite the index.php of Codeigniter on Windows Azure
  10. HTTP OPTIONS error in Phil Sturgeon’s Codeigniter Restserver and Backbone.js
  11. Uploading a csv into Codeigniter
  12. Using Mysql WHERE IN clause in codeigniter
  13. Constructor session validation for different functions
  14. How to upload image in CodeIgniter?
  15. COUNT / GROUP BY with active record?
  16. Correct naming structure for CodeIgniter
  17. PostgreSQL next value of the sequences?
  18. How to integrate codeIgniter with netbeans fully
  19. Where do I put image files, css, js, etc. in Codeigniter?
  20. Upstream too big – nginx + codeigniter
  21. how to load view into another view codeigniter 2.1?
  22. how to validate array value in codeigniter
  23. CodeIgniter session class not working in Chrome
  24. codeigniter table join
  25. codeigniter : Commands out of sync; you can’t run this command now
  26. how to select only one value sql
  27. Multiple files upload in Codeigniter
  28. How can I detect a create, update, delete query is successful in Codeigniter
  29. CodeIgniter activerecord, retrieve last insert id?
  30. How to stop GD2 from washing away the colors upon resizing images?

Leave a Comment