MySQL BETWEEN operator

PHP MySQL: How to Check if a Date Falls Between Two Dates