[SOLVED] Time Comparison against minutes

[SirChick]

How do you do a time comparison against a time stamp in the database: $Started = ['Started'];

And a time representing now : $Date = date("Y-m-d H:i:s",time());

 

But i wanted the difference from now to the start to be given back in minutes only..how is this done?

[GingerRobot]

You can do it all with mysql functions:

 

SELECT TIME_FORMAT( TIMEDIFF( NOW( ) , `yourfield` ) , '%i' ) AS difference FROM `yourtable` 

 

This will return the number of whole minutes between your timestamp and the current time.

[SirChick]

%i

 

whats that bit do ^?

[GingerRobot]

Its the format string for minutes. See:

 

http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_date-format

[SirChick]

How do you then just put the result into $Difference ?

[GingerRobot]

<?php
$sql = "SELECT TIME_FORMAT( TIMEDIFF( NOW( ) , `yourfield` ) , '%i' ) AS difference FROM `yourtable`";
$result = mysql_query($sql)or die(mysql_error());
$difference = mysql_result($result,0);
// or ,if you are selecting other fields as well: $difference = mysql_result($result,0,'difference');
?>