PHP / SQL - 从两个日期之间的SQL查询返回布尔结果

I've been asked to build a scheduler to display special offers on a website based on start/end dates. Part of that is to conditionally display a link to the page if there is a valid offer in place. But I'm completely at a loss.I've been asked to build a scheduler to display