<? $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>"; } ?>