Getting a list of email addresses from forum members

[tuslic]

I'm trying to collect the email addresses from my forum to start a email blast group but I have over 20,000 members so I'm trying to figure out is there anyway or any mod I can get that will generate a list of all the email addresses without me manually going threw each one?

[nexialys]

simply query your database to select all your members email, and write down the result... this may be a 5 seconds query...

[Symbian Galaxy]

can you tell me the query?

[nexialys]

SELECT email from " . TABLE_PREFIX . "user

ya know, if you can't figure this out, ask a coder to code the tool for you.

---NOT ME!

[Symbian Galaxy]

i dont have ne table prefix wat will be the query in that case

[Yours]

table prefex is almost always db_

[0tolerance]

uhm... dude, just go into phpmyadmin and run the query... your host should provide it.