On Monday 10 February 2003 06:57, Barrie Matthews wrote:
> 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 CUR
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()