You can trying using the MySQL DATE_ADD() , DATE_SUB , and NOW()
functions.
-wendell frohwein
-Original Message-
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
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:[EMAIL PROTECTED]
Sent: Friday, October 08, 2004 11:36 AM
To: [EMAIL PROTECTED]
http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html
That web page has tons of details.
metin
Cole S. Ashcraft wrote:
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:
Cole,
I don't know the full context of how you need to do your date math. However,
what if, instead of selecting a bunch of data and putting it in an array in
PHP then checking to see if its older than 14 days you wrote your query to
pull only those records that are older than 14 days?
Something
: Friday, October 08, 2004 2:57 PM
To: 'Cole S. Ashcraft'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] -14 Days Ago
You can trying using the MySQL DATE_ADD() , DATE_SUB , and NOW()
functions.
-wendell frohwein
-Original Message-
From: Cole S. Ashcraft [mailto:[EMAIL PROTECTED
That would probably work, and its not too hard to do a rows returned check.
Richard Hutchins wrote:
Cole,
I don't know the full context of how you need to do your date math. However,
what if, instead of selecting a bunch of data and putting it in an array in
PHP then checking to see if its older
Cole S. Ashcraft wrote:
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 h5Assignment In Void:/h5brh4Assignments in the void are
read-only;