date() functions

[beezZa]

Ok in a nutshell the project im playing with a resume builder site. They want to have a stipulation that only allows the resume to be downloaded for 90 days.

When the user makes the resume the initial date would be stored in the database. How would i add 90 days to that considering that diff months have diff amount of days.

IM A NEWB. HELP!!!

[bradgrafelman]

How do you retrieve info for each resume? Is there some "resumeID" value you pass via the URL or something? If so, you could do something like:

$query = "SELECT IF(time_upload < NOW() - INTERVAL 90 DAY, NULL, filename) FROM foo WHERE id=$id";
$exec = mysql_query($query);
$file = mysql_result($exec, 0);

if($file === NULL) {
	// resume must be older than 90 days, or one was never uploaded
} else {
	// $file contains the "filename" column value
}