[ForYou]

Hello ,

Look !!

when I need to remove Mod from the orginal list , what is the wrong



Invalid SQL:

SELECT user.userid, usergroupid, username, displaygroupid, moderatorid
FROM moderator AS moderator
INNER JOIN user AS user USING(userid)
WHERE moderatorid = 114;

MySQL Error : Column 'usergroupid' in field list is ambiguous
Error Number : 1052
Date : Thursday, September 1st 2005 @ 12:14:59 AM
Script : http://www.XXXX.net/xx/admincp/moderator.php
Referrer : http://www.XXXX.net/xx/admincp/moderator.php
IP Address : 83.244.4.145
Username : XXXX
Classname : vb_database