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

[Barrie Matthews]

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...
}

I can't seem to find date functions that are of any use for this.

Thanks in advance.
 


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

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

[John W. Holmes]

 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...
 }
 
 I can't seem to find date functions that are of any use for this.

I could have sworn I already answered this today...

SELECT ... FROM table WHERE CURDATE() BETWEEN start AND end

Where 'start' and 'end' are your columns...

It's slightly faster to use CURDATE()  start AND CURDATE  end, but I
find BETWEEN easier to read...

---John W. Holmes...

PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/



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