[SQL] Search for available personnel |
@user4852
...or (https://www.codeigniter.com/userguide3/d...y-bindings ) $sql = "SELECT * FROM order_details Where your_date >= ? and your_date <= ?"; $this->db->query($sql, array('2014-02-01', '2014-02-28')); or If you have to cast the strings as dates... $sql = "SELECT * FROM order_details Where your_date >= CAST(? as DATE) and your_date <= CAST(? as DATE)"; $this->db->query($sql, array('2014-02-01', '2014-02-28')); |
Messages In This Thread |
[SQL] Search for available personnel - by user4852 - 11-26-2018, 01:13 AM
RE: [SQL] Search for available personnel - by InsiteFX - 11-26-2018, 10:48 AM
RE: [SQL] Search for available personnel - by php_rocs - 11-26-2018, 11:51 AM
|