best practices date comparison

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