[Kamron3]

I'm trying to figure out how to create a successful code that pulls all the current users that are logged in and posts them in order from 0-9, A-Z AND also calculates how many users are currently online. If anyone would be as kind as to point me in the right direction, as it would be very appreciated.

Kamron3

This post has been edited by Kamron3: 23 March 2010 - 03:22 PM

[eddiehm]

This really isn't too hard if you think about it. Take a swing at it then post what you have. After that I'll give you some more hints. But the best thing to do is just take a swing at it try the logic out then go from there.

[Kamron3]

I think it has something to do with setting a MySQL database for "online = 1" when a user's session is valid. Then a PHP script will go thru the row of all users with the online equivilent to one and display that onto the page...

But I do not know how to code that. I know what to do, just can't code it myself. Right now I have the login script that I got and I have it set the right variables and other things.

_k

[no2pencil]

Quote

But I do not know how to code that

I've used this tutorial for just this same purpose on a few sites.

[Kamron3]

This tutorial only shows the code for how many users are online. Not which users are online.

_k

[no2pencil]

It's a start. Tell me you can't return both the username & who's online from following that tutorial... it's really really simple.

[Lochie]

no2pencil, on 27 March 2010 - 09:33 PM, said:

It's a start. Tell me you can't return both the username & who's online from following that tutorial... it's really really simple.

Well, in case he CAN'T, here's the code.

$offline = time() - 600;
$query = mysql_query("SELECT * FROM users WHERE online >= $offline");
while($user = mysql_fetch_array($query)){
    echo($user['username']);
}