I've searched all over for this, and I seem only to find how to get records where a single date is between two "outside" dates.
I want to find out how to select records where the current date is between the value in the startDate field and the value in the endDate field.
What I have so far (PHP):
$now = new DateTime(); $sql = " SELECT content, image, imageHeight, imageWidth, link, linkDescription FROM news WHERE appearanceDate < $now AND $now < termDate ORDER BY appearanceDate DESC ";
But it doesn't work.