MYSQL query works fine when run in Sequel Pro but returns nothing via PHP

     

I'm trying to run a simple MYSQL query to return all rows where "created" is between 2 dates. My query works fine when run in Sequel Pro but returns nothing when run via PHP.


Heres the MYSQL query:


SELECT * FROM `bookings` WHERE `accountid` = 111111 AND `propertyid` = 10 AND `created` BETWEEN "2017-05-17 00:00:00" AND "2017-05-17 23:59:59"  

That returns one row which is expected.


The PHP code (I've hardcoded the dates for testing):


public function get_property_bookings_made ($accountid $propertyid $checkdate) {   $query = $this->db->prepare("SELECT * FROM `bookings` WHERE `accountid` = ? AND `propertyid` = ? AND `created` BETWEEN ? AND ?");   $query->bindValue(1