time comparison

[EchoFool]

I need help working out how to compare the difference in seconds between two time stamps... i keeps returning 0 as a result.. this is what i have at the moment:

 

<?php
$User1HitTime = 2008-10-17 17:34:42;
$Date = 2008-10-17 18:39:43;

			If($Att == $_SESSION['Current_User']){
				$Date = $Date - $User1HitTime;
Echo $Date;
					If($Date < 2){
					$Second = 1;
					}
			}
?>

 

The Echo of $Date comes out as 0... when it should surely not be?

 

What did i do wrong?

[discomatt]

Are you getting these timestamps from a database?

[EchoFool]

$Date = server time of "now"

 

And $User1HitTime is from a table in Timestamp format. I just put examples in to the above so some one could see what might be going wrong.

[xylex]

That code parses for you?

 

Try

<?php
$User1HitTime = "2008-10-17 17:34:42";
$Date = "2008-10-17 18:39:43";

			If($Att == $_SESSION['Current_User']){
				$Date = strtotime($Date) - strtotime($User1HitTime);
Echo $Date;
					If($Date < 2){
					$Second = 1;
					}
			}
?>

 

[discomatt]

By table... do you mean a table in a MySQL database? if so, select it like this

 

SELECT UNIX_TIMESTAMP(`dateColumn`) as `dateColumn` FROM `table`....

 

Then simply use

 

$difference = abs( time() - $User1HitTime );

[EchoFool]

  Quote

By table... do you mean a table in a MySQL database? if so, select it like this

 

SELECT UNIX_TIMESTAMP(`dateColumn`) as `dateColumn` FROM `table`....

 

Then simply use

 

$difference = abs( time() - $User1HitTime );

 

shall give it a try thank you.

[PFMaBiSmAd]

What is your overall goal? There is probably a way to do it much faster directly in a query.

[EchoFool]

To check if 2 seconds has passed from the timestamp in the database to "now". To prevent double inputs.

 

When two seconds has not passed $Seconds = 1 (or TRUE) which i then use further down the script to stop two inputs occuring.