Quote:
Originally Posted by Paul M
What version of VB ?
|
3.54
I have checked the footer and that looks good.
SELECT username, email, usergroupid, membergroupids, languageid, retaileremailaccept
FROM " . TABLE_PREFIX . "user
WHERE usergroupid ='9' OR membergroupids ='9'
AND retaileremailaccept = '0'
I ran the above SQL via PHPAdmin and it pulls the correct number of users.
Thanks for the reply and help!