Re: getting a date 25 years back

Merlin wrote:

Hi there, 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 use mktime() and subtract 25 from the year argument. Or just do it in your query... SELECT * FROM yourtable WHERE your_date_column < NOW() - INTERVAL 25 YEAR; -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals – www.phparch.com