Last Online

[conker87]

I have a little 'last online' code on my members list page that adds 'online' or 'offline'.

 

When the person logs in, then the lastOnline field is updated to current time (with time()).

 

This is the code that determines if the user has logged out

<?php
				$lastOnlineGetQuery	= "SELECT `lastOnline` FROM `members` WHERE `username` = '{$memberArray['username']}'";
				$lastOnlineGet	= mysql_query($lastOnlineGetQuery);
				$lastOnlineGetResult	= mysql_result($lastOnlineGet, 0, "lastOnline");
					//echo $lastOnlineQueryGet . "<br />";
					//echo $lastOnlineGetResult . "<br />";
			if ($onlineGet - time() < 1800) // It's been less than half an hour since they did anything
				{
					echo "<font style=\"font-variant: small-caps; color: green;\">ONLINE</font>";
				}
			else
				{
					echo "<font style=\"font-variant: small-caps; color: red;\">OFFLINE</font>";
				}
?>

 

Only, it's not working! It shows ONLINE or OFFLINE for all members. Note that this code is within the while() code that shows all the members.