Help with Time?

[lalnfl]

How would you get ten minutes ago from the current time?

[kenrbnsn]

I would use strtotime

<?php
$ten_minutes_ago = strtotime('-10 minutes');
?>

 

Ken

[lalnfl]

It doesn't seem to work when I do this.

 

$time = time() - $ten_minutes_ago;

 

it just shows 600 when I echo it

[milesap]

It doesn't seem to work when I do this.

 

$time = time() - $ten_minutes_ago;

 

it just shows 600 when I echo it

 

Ahaha 600 seconds is 10 mins . . . Just divide 600 by 60 to display it in minutes.

[lalnfl]

I know that it was displaying seconds. My problem is that I want it to subtract it from the current time. How would you do that?

[kenrbnsn]

In my example, the variable $ten_minutes_ago is the time in seconds of ten minutes ago. You don't have to subtract it from anything. If you do you will get 600.

 

Ken

[lalnfl]

Oh so the strotime already subtracts 10 minutes from the current time?

[kenrbnsn]

The strtotime function can do a lot of things with the time. I suggest you read the manual page.

 

Another way of getting the time 10 minutes ago is:

<?php
$ten_minutes_ago = time() - 600;
?>

 

Ken

 

[jcbones]

echo date('m/d/Y h:i:s A',strtotime('-10 minutes'));

[lalnfl]

Okay I have another question. Why isn't this SQL query working???

 

$sql_members_online = mysql_query("SELECT last_login_date FROM Member WHERE last_login_date BETWEEN '$time' AND '$current_time'");

 

 

the $time is the time with 10 minutes subtracting from the current time

 

and there is a last_login_date with datetime field, its just called last_login_date

 

Any ideas?

[jcbones]

echo the query to make sure the variables are defined as you think they should be.  This is one reason to set the query in it's own variable.

 

$sql = "SELECT last_login_date FROM Member WHERE last_login_date BETWEEN '$time' AND '$current_time'";
$sql_members_online = mysql_query($sql) or die('Error: ' . $sql . '<br />' . mysql_error());

 

[lalnfl]

They are and I am still getting 0 as a result when I use mysql_num_rows.

[kenrbnsn]

What are the formats of the different fields? DATE, DATETIME, or UNIXTIME?

 

Ken

[lalnfl]

last_login_date is DATETIME and I assume $time and $current_time is UNIXTIME

[jcbones]

So you are checking an actual date, against seconds?  And, it doesn't work?

[lalnfl]

I am checking to see if last_login_date is between the Current Time and the time 10 Minutes ago.

[lalnfl]

Anyone know what I am doing wrong?

[lalnfl]

Bump

[Pikachu2000]

As long as your data type is DATETIME, see my response in this thread. It should give you a good idea of how to approach this.