Filtering a recordset based on 'todays' date - how to compare a start date and end date?

What is wrong with this...

<?php
@session_start();
if("" == "")     {
  $_SESSION["todaySESH"] = " ". date('d M Y h:m:s')." ";
}
?>

<?php
$rsLIVECOMP = new WA_MySQLi_RS("rsLIVECOMP",$csdbmysqli,1);
$rsLIVECOMP->setQuery("SELECT dreamcarCOMPID, dreamcarCOMPDATESTART, dreamcarCOMPDATEND, dreamcarCOMPTITLE, dreamcarCOMPSUMMARY, dreamcarCOMPTEXT, dreamcarCOMPIMG, dreamcarCOMPDELETE FROM dreamcarCOMPS WHERE dreamcarCOMPDATESTART <= ? AND dreamcarCOMPDATEND >= ?");
$rsLIVECOMP->bindParam("t", "".(isset($_SESSION['todaySESH'])?$_SESSION['todaySESH']:"")  ."", "-1"); //colname
$rsLIVECOMP->bindParam("t", "".(isset($_SESSION['todaySESH'])?$_SESSION['todaySESH']:"")  ."", "-1"); //colname1
$rsLIVECOMP->execute();
?>

I want to only show results where the competition start date is less than, or equal to, today's date/time but ALSO where the end date is greater than, or equal to today's date.

I'm trying to only show competitions that are available during their start and end dates.

At present, using the above, it displays any competition regardless of the dates in the database.

Hope you can help. Thank you.
NJ

You shouldn't need to use parameters or session variables. You can just use:

SELECT dreamcarCOMPID, dreamcarCOMPDATESTART, dreamcarCOMPDATEND, dreamcarCOMPTITLE, dreamcarCOMPSUMMARY, dreamcarCOMPTEXT, dreamcarCOMPIMG, dreamcarCOMPDELETE FROM dreamcarCOMPS WHERE dreamcarCOMPDATESTART <= CURDATE() AND dreamcarCOMPDATEND >= CURDATE()

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

It is probably using US format. 07/06/2017 12:00:00 is next month. Try 05/05/2017 and see if that works. Is that field set as a type Date/Time field?

No, because if I change it to 06/06/2017 12:00:00 it picks it up correctly. It's like it's out by one day?

DATETIME field, yes.

06/06/2017 is in the past in US format.

What about when you enter 06/15/2017. I think the database is just using US date format.

When I enter 06/15/2017, via ODBC connection in Access, it auto changes to 15/06/2017.
How do I fix this? The client inserts the date via a date picker in an admin section and it's inserting in the correct format, or so I thought.

Thank you.
NJ

It may be that your Access database is set to European date format and the MySQL database is set to US format. What happens when you update from phpMyAdmin directly?

In phpMyAdmin:
"Warning #1265 Data truncated for column 'dreamcarCOMPDATESTART' at row 1"

Thing is, the date picker on the website is inserting in UK format and the database accepts it and displays it properly. It's only the SELECT statement that's misinterpreting it.

Urggh, this is messy. What am I doing wrong?
NJ

If you use dashes instead of slashes then the php understands the date format and enters it properly. MySQL only accepts the date format YYYY-MM-DD, so all dates are converted to that before inserting or updating.