How to query a table to display events on the current date (MySQLi Recordset)
I have the following MySQLi recordset on my page...
<?php
$rsEVENTS = new WA_MySQLi_RS("rsEVENTS",$SMTmysqli,10);
$rsEVENTS->setQuery("SELECT * FROM SMTevents WHERE SMTevents.SMTeventdate >= Now()");
$rsEVENTS->execute();
?>
...but this doesn't display events that are taking place on the current date. I tried this, which doesn't produce an error, but it doesn't resolve the issue:
<?php
$rsEVENTS = new WA_MySQLi_RS("rsEVENTS",$SMTmysqli,10);
$rsEVENTS->setQuery("SELECT * FROM SMTevents WHERE SMTevents.SMTeventdate >= (Now()-1)");
$rsEVENTS->execute();
?>
What should my SELECT statement be?
Thank you.
NJ