Sat, Mar 24 2007 12:03:10 +0800
Veen Script: /home/webadmin/jakchat.com/html/forums/scripts/showmembers.inc.php - Line: 215
SELECT t1.USER_DISPLAY_NAME,t1.USER_REGISTERED_ON,t2.USER_HOMEPAGE,t2.USER_TOTAL_POSTS,t1.USER_MEMBERSHIP_LEVEL,t1.USER_ID,t2.USER_AVATAR,t2.USER_AVATAR_WIDTH,t2.USER_AVATAR_HEIGHT
FROM ubbt_USERS as t1,
ubbt_USER_PROFILE as t2
WHERE t1.USER_IS_APPROVED = 'yes'
AND t1.USER_ID <> 1
AND t1.USER_IS_BANNED = '0'
AND t1.USER_ID = t2.USER_ID
AND (t1.USER_IS_UNDERAGE <> '1' OR t1.USER_IS_UNDERAGE IS NULL)
AND t1.USER_DISPLAY_NAME LIKE 'p%'
ORDER BY t1.USER_DISPLAY_NAME ASC
LIMIT -25, 25
- 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 '-25, 25' at line 11
