I need to see if a time() is 7 days greater than a time() variable stored in db

[jeff_borden]

how would you do this? thx in advance....

[dalecosp]

Originally posted by jeff_borden
how would you do this? thx in advance....

Subtract!!! 🙂

Seriously, care to post some code?

[jeff_borden]

in the code i need to check to see if $day is at least 7 days less than $day2

$query_week = "SELECT MAX(received) FROM ".$db." WHERE folder = 'sent'";
$result_week = mysql_query($query_week);
$received = mysql_result($result_week,0, 0);

			$date_time_array =  getdate($received);

			$hours =  $date_time_array[ "hours"];
			$minutes =  $date_time_array["minutes"];
			$seconds =  $date_time_array[ "seconds"];
			$month =  $date_time_array["mon"];
			$day =  $date_time_array["mday"];
			$year =  $date_time_array["year"];
			$time2 =  mktime($hours ,$minutes, $seconds,$month ,$day+7,$year);

			$date_time_array2 =  getdate($time2);
			$day2 =  $date_time_array2["mday"];

thx

[dalecosp]

Originally posted by jeff_borden
in the code i need to check to see if $day is at least 7 days less than $day2

Well, mktime() gives seconds since the epoch. Do maketime() for both days; compute a difference. If the difference is larger than 604800, you're OK. Basically something like:

$date=mktime($some_vars)  // first set of data
$date2=mktime($some_other_vars) // your second set of data
if ($date2 > ($date+604800)) {
      foobar();
    }

[crewcialdotorg]

you can also do this within mysql.

select time from tbl where time > subdate(NOW(), interval 7 day))

can't quite remember which way the > goes but, toy around with it.

[jeff_borden]

cool got it thanks so much for the help...