Need help determining time difference

[schwim]

Hi there guys,

I'm trying very hard to figure out a way to determine whether current time is 60 minutes past a stored time. I am having a horrible time. Here's what I've got:

<?php

include("./includes/header.php");

//Check to see whether cron needs to run.
$query = "SELECT DATE_format(roster_update, '%b %d %Y %h:%i %p') as roster_update, DATE_format(NOW(), '%b %d %Y %h:%i %p') as cur_time FROM addon_cron";
$result = mysql_query ($query) or die('MySQL error: ' . mysql_error() . '<hr/>' . $query);
$result_rows = mysql_num_rows($result);
if($result_rows==0){

//Danger, Will Robinson!  No data found in db for cron!
echo("
Error: Cron time missing for roster_update.
");

}else{

//Grab the last run time for roster_update
$result = mysql_query ($query);
while ($row = mysql_fetch_assoc ($result)) {
	$roster_update = strtotime($row['roster_update']);
	$cur_time = strtotime($row['cur_time']);		

	echo $roster_update."<br />".$cur_time."<br />";

	if($cur_time >= ($roster_update+(60*60))){

		echo("<p align='center'>Over 60 minutes.</p>");


	}else{

	// Time is under one hour.
	echo("<p align='center'>under 60 minutes.</p>");

	}
}
}

?>

I've set the database time four hours in the past and it's still telling me that it's under an hour.

Could someone tell me how To get this to work?

Thanks a bunch for your time!

[Derokorian]

You can do all the work in your query, and simplify things. Note I didn't check for a successful query or rows returned in this code. The query was tested, but you'll have to add your error checking.

$$qry = "SELECT
			IF(
				CEIL(
					TIME_TO_SEC(
						TIMEDIFF( CURTIME( ) , roster_update )
					) / ( 60 * 60 )
				) > 1,
				1,
				0) AS updated 
			FROM addon_cron";
$res = mysql_query($qry);
$row = mysql_fetch_array($res);
if( $row['updated'] == 0 ) {
   echo "<p align='center'>under 60 minutes.</p>";
} else {
   echo "<p align='center'>Over 60 minutes.</p>";
}

[schwim]

Hi there and thanks for the reply. I tried the code and got under 60 minutes even after setting roster_update to May 10, 2012. I didn't make any changes to the code.

<?php

include("./includes/header.php");

$qry = "SELECT
            IF(
                CEIL(
                    TIME_TO_SEC(
                        TIMEDIFF( CURTIME( ) , roster_update )
                    ) / ( 60 * 60 )
                ) > 1,
                1,
                0) AS updated
            FROM addon_cron";
$res = mysql_query($qry);
$row = mysql_fetch_array($res);
if( $row['updated'] == 0 ) {
   echo "<p align='center'>under 60 minutes.</p>";
} else {
   echo "<p align='center'>Over 60 minutes.</p>";
}

?>

The query is very far above my paygrade, so I'm finding it impossible to even follow the logic of it, unfortunately. Is there something you might see at second glance that would cause my problem?

Thanks very much for your time.

[Derokorian]

My bad, I misunderstood I thought you were using a time column. Try this query instead:

SELECT 
            IF( 
                CEIL( 
                    TIME_TO_SEC( 
                        TIMEDIFF( NOW( ) , roster_update ) 
                    ) / ( 60 * 60 ) 
                ) > 1, 
                1, 
                0) AS updated
            FROM addon_cron

[Derokorian]

You know I had that originally, but it wasn't working on a time column - didn't even bother to try again for some reason when I changed to datetime XD