note 27701 added to function.date

There are several people here trying to add/subtract from timestamp values in MySQL. This *can* work, but it can also go horribly wrong. The correct way is to do something like this: $query = "SELECT DISTINCT foo1, foo2, foo3 FROM table WHERE TO_DAYS(NOW()) - TO_DAYS(foo2) <= 7 ORDER BY foo2 ASC;" MySQL then works out 7 days prior to NOW. Even if today was the 6th, for example. Of course, if time was decimalised, things would be so much easier! -- http://www.php.net/manual/en/function.date.php http://master.php.net/manage/user-notes.php?action=edit+27701 http://master.php.net/manage/user-notes.php?action=delete+27701 http://master.php.net/manage/user-notes.php?action=reject+27701