SQL Error : 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 'ORDER BY u.username' at line 7
SELECT u.username, u.user_id, u.user_viewemail, u.user_posts, u.user_regdate, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_msnm, ug.user_pending
FROM phpbb_users u, phpbb_user_group ug
WHERE ug.group_id = 6
AND u.user_id = ug.user_id
AND ug.user_pending = 0
AND ug.user_id <>
ORDER BY u.username
FAQ
Search
Memberlist
Usergroups
Register
Profile
Check PMs
Log in
