check all who are online

[scraff]

hi,

I am currently in the middle of developing a game in Flash (that game being multiplayer Worms) that uses PHP and MySQL to send/ retrieve data. The game will check a table in a data base to see who is online, but i cant work out how!

When players loggon, the collum under 'connected' where username is there username, is set to true.

How do i go through the table and check all the enties where 'connected' is = to 'true', and return the usernames?

Also, how do i return every username in the table so i can show all who are registered?

THANKS ALOT!

[OhLordy]

The way I do it on my forum is that every time a user moves from one page to another it inserts a timestamp next to their name in the ppl online table and then checks to see if any of the other entries have timestamps older than 30 secs. If any of them do they get deleted.
The result of this is that the ppl online table contains the user id's of all ppl that have been active on the site in the last 30 secs.
Cheers
Rob

[scraff]

Ive sorted it now, using fetch:

<?php

mysql_connect ($host, $user, $pass)
or die ('I cannot connect to the database. Make sure that mysql is installed and that you are trying to log in as a valid user.');

mysql_select_db ("$Name")
or die ('The database specified in database_name must exist and must be accessible by the user specified in mysql_connect');

$query = "SELECT * FROM $table";
$query_result_handle = mysql_query ($query)
or die ('The query failed! table_name must be a valid table name that exists in the database specified in mysql_select_db');

$num_of_rows = mysql_num_rows ($query_result_handle)
or die ("The query: '$query' did not return any data");

//print "The query: '$query' returned $num_of_rows rows of data.";

for ($count = 1; $row = mysql_fetch_row ($query_result_handle); ++$count)
{
print "

";
print "$row[0] , ";

}
?>

This just prints all the values in row 0, which is the username here.
Ta