Not displaying old data...

[Anon]

Hello,
I have a PHP script that uses MySQL. The script searchs the MySQL database, and returns the fields that match what the user put into the search form. However, I don't want the script to display data that was posted 60 or more days ago. Anyone know how I could do this? I was thinking about date("z"), where it shows what day of the year it is, and then subtracting that from the day of the year the data was posted. If it was greater than or equal to 60, then it wouldn't show. Thanks for your help in advance.

-Mike

[Anon]

There are different ways to check that...
If you use a timestamp to store your dates, you can do something like this:

// Current date - 60 days...
$min = time() - 60 60 24 * 60;

SELECT * FROM table WHERE date >= $min

Or... when you use mysql date or datetime field, you can do it this way:

SELECT * FROM table WHERE date >= DATE_SUB(date, INTERVAL 60 DAY)

Hope it helps...

Greetz,
Daniel