Richard Lynch wrote:
Merlin wrote:
I am trying to create a date which is 25 years back from today. The
purpose of
this is to be able to query a mysql database "date" field for columns
smaller
than this date.
I tried this:
$years = 25;
//> $start_from = date("Y-m-d",strtotime("- ".$years." year"));
Somehow it always ads the years instead of subtracting.
Has anybody an idea on how to do that?
You can do this in all MySQL:
select ... where date_field <= sub_date(now(), interval 25 years)
Or you could try:
$back_then = mktime(0, 0, 0, date('m'), date('d'), date('Y') - 25);
$start_from = date("Y-m-d", $back_then);
thank you everybody for your help.
I used this which works excellent:
$back_then = mktime(0, 0, 0, date('m'), date('d'), date('Y') - 25);
Thanx, Merlin
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
