I have the start date set, just now in the database, as "07/06/2017 12:00:00" however it's not picking it up even though that date is less than or equal to CURDATE().
<?php
$rsLIVECOMP = new WA_MySQLi_RS("rsLIVECOMP",$csdbmysqli,1);
$rsLIVECOMP->setQuery("SELECT dreamcarCOMPID, dreamcarCOMPDATESTART, dreamcarCOMPDATEND, dreamcarCOMPTITLE, dreamcarCOMPSUMMARY, dreamcarCOMPTEXT, dreamcarCOMPIMG, dreamcarCOMPDELETE FROM dreamcarCOMPS WHERE dreamcarCOMPDATESTART <= CURDATE() AND dreamcarCOMPDATEND >= CURDATE()");
$rsLIVECOMP->execute();
?>
dreamcarCOMPDATESTART = 07/06/2017 12:00:00
dreamcarCOMPDATEND = 14/06/2017 12:00:00
Hope you can help. Thank you.
NJ