Welcome Guest, Not a member yet? Register   Sign In
[SQL] Search for available personnel
#3

@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'));
Reply


Messages In This Thread
RE: [SQL] Search for available personnel - by php_rocs - 11-26-2018, 11:51 AM



Theme © iAndrew 2016 - Forum software by © MyBB