Re: How to query for rec's WHERE >= $start_date ?

[Fran Lee]

Here is the answer...

$dt="2017/12/01"; // note no back ticks inside the quotes
$dt = mysqli_real_escape_string($conn,$dt);
$dt = "'".$dt."'"; // now add the back ticks before you use the string in a query



In other words pass the date as a string without the back ticks and then...
... once you have run it through the mysqli_real_escape_string function
... add the back ticks so it will work in the query

Turns out mysqli_real_escape_string strips out the back ticks... that is why it seems you have to do it this way.

This seemed to work for me but if I am incorrect, please let me know.

Thanks.