Re: -14 Days Ago
| From: | Cole S. Ashcraft | Date: | Fri, 08 Oct 2004 19:00:47 +0000 |
| Subject: | Re: -14 Days Ago | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-36698@lists.php.net to get a copy of this message | ||
I needto do it in PHP, though.
Cole
Wendell Frohwein wrote:
You can trying using the MySQL DATE_ADD() , DATE_SUB , and NOW() functions. -wendell frohwein -----Original Message----- From: Cole S. Ashcraft [mailto:csa@ashcraftfamily.net] Sent: Friday, October 08, 2004 11:36 AM To: php-db@lists.php.net Subject: [PHP-DB] -14 Days Ago I am trying to see whether a data in an array pulled from a MySQL DB (YEARMONTHDATE) is older than 14 days ago. I am trying to do this in PHP. My code looks like: if($array['due'] <= $today - 14) { echo "<h5>Assignment In Void:</h5><br><h4>Assignments in the void are read-only"; require('footer.php'); exit; }. I am having problems with the math. How do I do a date subtraction without ending up with something like 20040994 (not a valid date)? Thanks, Cole