phpBB.de

Code: Alles auswählen

$sql="SELECT u.username, u.user_session_time, r.rank_title, r.rank_min, u.user_posts, s2.mymin
FROM phpbb_users u, phpbb_ranks r, (

SELECT username, max( rank_min ) mymin
FROM `phpbb_users` , phpbb_ranks
WHERE phpbb_ranks.rank_min <= phpbb_users.user_posts
GROUP BY username
)s1, (

SELECT username, min( rank_min ) mymin
FROM `phpbb_users` , phpbb_ranks
WHERE phpbb_ranks.rank_min > phpbb_users.user_posts
GROUP BY username
)s2
WHERE s1.username = s2.username
AND s1.username = u.username
AND s1.mymin = r.rank_min
AND s1.username <> 'Anonymous'
ORDER BY $order_by ";

Code: Alles auswählen

#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT username , max( rank_min ) as mymin  FROM `phpbb_users`