note 9108 deleted from function.getdate by danbrown
| From: | danbrown@php.net | Date: | Sun, 20 Jul 2008 03:09:05 +0000 |
| Subject: | note 9108 deleted from function.getdate by danbrown | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-142028@lists.php.net to get a copy of this message | ||
Note Submitter: ih2 at morton-fraser dot com
----
To do comparisons on dates stored in mysql db against 7 days ago, 1 month ago etc use the following:
$last_week = date("Y-m-d", mktime(0,0,0, date(m), date(d)-7,date(Y)));
if($date > $last_week)
{
etc.
This allows for intelligent looping i.e. works at start/end of month/year
I have noticed other postings re this and they have not worked for me.Hope this helps.