Working out minutes from mysql

[graham23s]

Hi Guys,

i was wondering if anyone could tell me the correct way to work out how long a go (in minutes) a user logged in, i have this for the number of weeks ago since they joined:

     // Get the users details from mysql...//////////////////////////////////////////////
     $query_1 = "SELECT id,username,login,user_class,about_me,country,avatar,join_date, FORMAT( DATEDIFF( NOW(),join_date)/7 ,0) AS join_date FROM `membership` WHERE `id`='$id'";
     $result_1 = mysql_query($query_1) or die (mysql_error());
     $row = mysql_fetch_array($result_1); 

but i'm not sure how to do the next query for minutes since they logged in.

thanks guys

Graham

[wheeler]

the php method I would use is

$start = strtotime($start);
$end = strtotime($end);
$duration = ($end - $start) / 60; 

not sure how to do in mysql, im sure someone in the mysql forums will know...

[r937]

select ( unix_timestamp()
        -unix_timestamp(loggedindatetime) ) / 60
                  as minutes_logged_in
  from ...

[graham23s]

Thanks guys, it displays like so:

6.7333 Minutes Ago 

is there any way to cut off the decimal point?

cheers

Graham

[spikeZ]

morning Graham, have a look at number_format()

edit

actually ignore number format and just use round();

round(6.7333); 

[Surgeon]

If you want to cut off the decimal point entirely.. you have a few options.

Do you want to round up or down?

If you want to round down: floor() is the function
If you want to round up: ceil() is the function

If you just want to chop off the decimal..

[/php]
$variable = 6.7893;
<?php
list($int, $dec) = explode(".", $variable);

echo $int;
?>
[/php]

This would give you 6 in the int variable, and 7893 in the dec variable. Hope that helps.

[graham23s]

That does indeed help thanks for that guys, iv learned a new function today aswell

thanks again

Graham