members online script...almost there

AutomatikStudio

Okay...I've read the numerous posts here on the forum about creating "members online" type scripts and have gotten the basic idea but now i'm getting a little confused about the timestamp issues...so here's what i've done so far....there is already a table in the database called "users" that has each users info...i added a field called "lastclick" which gets updated with at timestamp each time the user accesses a certain page. Now...what i'm trying to do is display the users active in the last 5 minutes...here's my php so far:

$result=mysql_query "SELECT * FROM users"; 
    if (!$result) { 
         echo("<p>Error performing query: " . mysql_error() . "</p>"); 
        exit(); 
       } 
    while($row = mysql_fetch_array($result)){
      echo $row['$playername'] }

but it's not working...and I still haven't figured out how to get the timestamp and only display activity within the last 5 min.

andrewm

What columns are there in your users table? Are you using a mysql timestamp column, a datetime column or a int/char column with a php timestamp?

AutomatikStudio

I'm using a TIMESTAMP column....my only problem now is getting the query to get the take the current time, subtract the TIMESTAMP from the current time and if it's within 5 minutes then display the members..

andrewm

Use this:

"... where (UNIX_TIMESTAMP() < (UNIX_TIMESTAMP(timestamp_column_name) + 300))"

UNIX_TIMESTAMP() - is the current time
UNIX_TIMESTAMP(timestamp_column_name) - formats the mysql timestamp to a unix timestamp
300 - is 5 minutes in seconds

AutomatikStudio

rock...that worked pefectly...thanks!

andrewm

Great!

Can you click the "Mark Thread Resolved (thread starter only)" link at the bottom of the page?