Show active users on a non-vB page

How would I do that? I'm trying to make my site look kinda like PHPnuke..

If somebody could help me make it please.

1 for show the current active users on a non-vB page (like TechTalk's newest member.. etc stuff)

and 1 to see if the user has logged in or not, if s/he has, then it would show "Welcome back _____", if s/he hasn't logged in yet.. then it would show the log in text boxes.

I've searched thru this forum already.. but I can't find what I need

Please & thanks.

<?

$action = mysql_query("SELECT s.userid, u.username FROM session s, user u WHERE u.userid=s.userid");

while (list($userid, $username) = mysql_fetch_row($action)) {
  echo "<a href="member.php?getinfo&userid=$userid">$username</a>";

}

?>

something like that

[Edited by Menno on 12-15-2000 at 10:58 AM]

Which one is that for Menno?

Could somebody give me the exact code tho?

Thanks.

this would be for the current active members

the query should be correct. All that is needed is ofcourse a mysql connection to the database:

mysql_connect($my_host, $my_user, $my_pass);
mysql_select_db($dbase);

Ahh, ty for that one.

Now could you tell me the code for showing "There are xx members & xx guests online" & seeing if the user has logged in or not.. if not then show the login boxes?

Thx a lot.