phpBB.de

Code: Alles auswählen

<?
$sql = "SELECT u.user_id, u.username, s.session_logged_in, s.session_time
		FROM phpbb_users u, phpbb_sessions s
		WHERE u.user_id = s.session_user_id
		AND s.session_time >= ".( time() - 300 ) . " AND u.user_id != -1
		ORDER BY u.username ASC, s.session_ip ASC";  

$result = mysql_query($sql);

print "<form name='form1' method='post' action=''>";
print   "<select name='select'>";

while ($row = mysql_fetch_array($result)) {
print    "<option value='t'>" . $row[1] . "</option>";
	}
	
print  "</select>";
print "</form>";

?>

Code: Alles auswählen

SELECT DISTINCT u.user_id, u.username...

Code: Alles auswählen

Select * FROM phpbb_users U
RIGHT JOIN phpbb_sessions S on U.user_id=S.session_user_id
WHERE S.session_user_id != -1
group by S.session_user_id
order by U.username,S.session_ip