[PHP-DB] Using CURDATE, DATE_SUB and DATE_ADD

deny access on Feb 10 but allow access starting on Feb 11? Thanks for any help. Barrie --- Barrie Matthews, Webmaster Heurisko Ltd, Learning Technology Specialists Spark House, 5 Durham St, PO Box 8577, Christchurch, New Zealand P +64 3 353

[PHP-DB] How to check that today's date is within a given range

I have a start_date and a finish_date stored in a mysql db. I want to check that today's date falls between these 2 dates. Can I set up the 3 dates so that a simple subtraction can be done? eg if (($today - $start 0) ($finish - $today 0)) { ...within range... } else { ...out of range... }