I needto do it in PHP, though.
Wendell Frohwein wrote:
You can trying using the MySQL DATE_ADD() , DATE_SUB , and NOW() functions.
From: Cole S. Ashcraft [mailto:[EMAIL PROTECTED] Sent: Friday, October 08, 2004 11:36 AM
To: [EMAIL PROTECTED]
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";
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)?
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php