Yet another problem with Session with DB

[eluser]WanWizard[/eluser]
If you include the user (some form of unique id), all you need to do is to run a DISTINCT query, and include MAX(last_activity) to get the most recent active one.

This doesn't say much about being online though, because it's not updated at every page request, only when the session_id rotates.