Log in

View Full Version : extracting emails ONLY from user database


wreck
08-16-2004, 11:29 PM
well thanks to rs-host.net i got my user database back.. but i cant install it because im using a different VB version now...

but im wondering if theres anyway of getting the emails without having to take them one by one from the database?

Modin
08-17-2004, 12:23 AM
upload the database and run this query on it


SELECT email FROM user


with phpmyadmin, after you do that you can click export (the one at the bottom) and export the results to a csv. :)

filburt1
08-17-2004, 01:15 AM
BTW, you are confusing terms. The user information is stored in a table. Tables are stored in a database. thread, post, user, etc. are tables, not separate databases.

wreck
08-17-2004, 10:37 AM
^^^my bad somebody called it a user database yesterday when they were helping me lol

as for uploading it, everytime i try it keep's giving me an error, but ill try it again and let you know... thanks

wreck
08-17-2004, 12:00 PM
WHEN U SAY UPLOAD... HOW DO U MEAN??? UPLOAD TO MY SERVER, OR UPLOAD THE TEXT FILE TO RUN AS A QUERY???

oops 4got i had caps lock on