Unable to get member's info via my sql
Hi,
I'm trying to get the mailing list by running the script below:
SELECT
userid,
username,
email,
joindate
FROM
user
WHERE
(options &16)
and usergroupid<>8
and userid > 22481
I worked fine until recently. the script only returns 81 records but the newest member id is 24790.
I checked the table "user" and new records are not saved there.
Please let me know which table I need to use.
Thanks.
Michelle
|