I am using the query below in attempting to control access to a web site.
The idea is that today's date must be between 1 month before the start date
and 1 month after the finish date.

$query1 = "SELECT VFT_name FROM `vft` WHERE CURDATE() >
DATE_SUB(VFT_date_start, INTERVAL 1 month) AND CURDATE() <
DATE_ADD(VFT_date_finish, INTERVAL 1 month) ";

It seems that if a start date is say March 31, then any date in February
(even Feb 01) is going to return true. I tried using days (28, 29, .. 35
etc) instead of 1 month in the query but that doesn't seem to work.

For a start-date of March 11 how can I deny access on Feb 10 but allow
access starting on Feb 11?

Thanks for any help.

Barrie Matthews, Webmaster

Heurisko Ltd, Learning Technology Specialists
Spark House, 5 Durham St, PO Box 8577, Christchurch, New Zealand
P +64 3 353-7360    F +64 3 366-5488
[EMAIL PROTECTED]        www.heurisko.co.nz

Heurisko services:
- LEARNZ, NZ's award winning online education programme www.learnz.org.nz/
- TheSchoolDaily - daily education news and features
- NZ agent for TextHELP! products - award winning learning disability
software www.texthelp.co.nz/
- Suppliers of digital cameras, scanners, printers and POLYCOMS
- Web server hosting and internet/intranet solutions

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to