2 replies to this topic

[Mr. Jay]

I am trying to get it to output like this
Example 1: (1 person)
User7
Example 2: (2 users)
User1, User7
Example 3: (3 users)
User1, User2, User7
Example 4: (No users)
No Users Online

This is what I got so far

<?php
	$conn = mysql_connect("localhost","mylogin","mypass");
	$db = mysql_select_db("test");
	$users_query = mysql_query("SELECT * FROM test_users ORDER BY lastactivity");
	$users_count = mysql_num_rows($user_query);
	if ($users_count > 1)
	{
		while($row = mysql_fetch_array($user_query))
		{
			if ($row['lastactivity'] > time())
			{
				echo $row['username'].", ";
			}
		}
	}
	else
	{
		echo "No Users Online";
	}
	mysql_close($conn);
?>

Edited by Mr. Jay, 23 July 2007 - 01:31 PM.

[Demonslay]

Implode works wonders, lol.

<?php
	$conn = mysql_connect("localhost","mylogin","mypass");
	$db = mysql_select_db("test");
	$users_query = mysql_query("SELECT * FROM test_users ORDER BY lastactivity");
	$users_count = mysql_num_rows($user_query);
	if($users_count > 0){
		while($row = mysql_fetch_array($user_query)){
			$users_online[] = $row['username'];
		}
		echo implode(', ', $users_online);
	}
	else{
		echo "No Users Online";
	}
	mysql_close($conn);
?>

I don't really get how the 'lastactivity' column could possibly be greater than the call to time(), since that would mean the last thing they did was in the future.

[Mr. Jay]

Thanks it worked perfect

The 'lastactivity' column is used for 5mins time after they clicked "time()*(60*5)", that way it don't show any unactive users