[SOLVED] unix time stamp

[soupy1985]

Hello Guys

 

I have a login system and I am trying to make a page that will display inactive users from the past 30 days. But i cant get it working.

This is what I have so far...

 

 

 

// $timestamp = 1220895924 gets this from the DB.

 

<?

 

 

  if (time() - $timestamp  > (30*24*60*60))

{

echo "inactive";

}

 

?>

 

[BlueSkyIS]

what's not working?

[soupy1985]

Nothing is happening.

[soupy1985]

Do i have to convert the time stamp to a time and date first?

[BlueSkyIS]

is $timestamp what you expect it to be? i'd check:

 

<?php
if (time() - $timestamp  > (30*24*60*60)) {
     echo "inactive: $timestamp";
} else {
     echo "active: $timestamp";
}
?>

[soupy1985]

Right i got that working, lol

 

 

Now i am trying to get who has been online in the last 30 min, any ideas?

 

 

  $sql = "SELECT * FROM members";
  $result = mysql_query($sql, $conn) or die(mysql_error());
  while ($newArray = mysql_fetch_array($result)) {
     
 $login = $newArray['login'];
  $timestamp = $newArray['timestamp'];	  
  
  if (time() - $timestamp  < (00*00*30*60)) {
  echo "$login<br>";
  }
    }

[BlueSkyIS]

Right i got that working, lol

 

 

Now i am trying to get who has been online in the last 30 min, any ideas?

 

 

  $sql = "SELECT * FROM members";
  $result = mysql_query($sql, $conn) or die(mysql_error());
  while ($newArray = mysql_fetch_array($result)) {
     
 $login = $newArray['login'];
  $timestamp = $newArray['timestamp'];	  
  
  if (time() - $timestamp  < (00*00*30*60)) {
  echo "$login<br>";
  }
    }

 

yes. multiplying anything by 0 equals 0.

[soupy1985]

Can someone break 30*24*60*60, what will it have to be to get 30 min?

[BlueSkyIS]

number of seconds per minute * number of minutes. 

[soupy1985]

What does it have to be to get it to get all the timestamps from the last 30 min?

 

if (time() - $timestamp  < (00*00*30*60)) { ????

 

[revraz]

You dont HAVE to do your compare like that, it's not a requirement that you use 4 sets of numbers, it just makes it easier to get to seconds.

 

So just use 1800.