Since you mentioned MYSQL, I'm assuming you have some sort of database query
in mind.  For instance, finding dates in a date field in a table in which 14
days from that field date is significant.

For instance, the following locates records whose records contain date
fields less than 14 days from today:

SELECT * FROM mytable WHERE mydate < DATE_ADD(now(), INTERVAL 14 DAY);

-----Original Message-----
From: Ben S. [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 12, 2001 11:49 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Date Calculation


How do you get the date that is 14 days from today's date?
I can get that date with mysql monitor but PHP. I am using PHP4 and MySQL. I
have tried many things but nothing works.
Does anyone give me a help?

Thank you.
Ben



--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to