Unable to get member's info via my sql

[hipgirl]

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

[Lynne]

I checked the table "user" and new records are not saved there.

What does this mean? Are you saying that new users are not getting a new record in that table?

[hipgirl]

Originally Posted by Lynne

What does this mean? Are you saying that new users are not getting a new record in that table?

Right. I ran the script below and the result is 22574 (which was created in Sep 2009). But after log in forum admin and search by join date, the max user ID is 26033 which was created today.

SELECT max( `userid` )
FROM `user`

max(`userid`)
22574


Thanks.

Michelle

[Lynne]

Have you taken a look at the table in the database? That just doesn't make sense.

[hipgirl]

Yes I did. I browsed the records in database, same as the query result.

I can general the correct mailing list from forum admin but the only field available is email address, there're no first name, last name available.

Thanks.

Michelle

--------------- Added [DATE]1259008187[/DATE] at [TIME]1259008187[/TIME] ---------------

Thank you for your time. The problem found.

I wasn't querying the correct database. I cloned a database when migrating to a new sever and I was still querying the old database.

Thanks.

Michelle