03/13/06 04:21am  

streamer

Anonymous
hello,
I find out that the Mail Utility within Geeklog is really slow when I send out mass emails to all users, thus I would like to export all email adresses from the whole user database. How can I do this? Is there any SQL command that reads out all adresses?

thank you for your help
 03/13/06 04:36am  
Status: offline

kr

Forum User
Newbie
Registered: 03/02/06
Posts: 4
Hi streamer,

getting all email addresses out of the database is really simple...

Just try this sql statement:
Text Formatted Code

SELECT email FROM `gl_users` WHERE email != 'NULL';


 
 03/13/06 04:53am  

streamer

Anonymous
perfect! thx for your fast help, kr!!
 03/13/06 07:45am  
Status: offline

1000ideen

Forum User
Full Member
Registered: 08/04/03
Posts: 1298
On the other hand it would be nice to understand IF and why geeklog is slow and what could be done against that.
 03/13/06 02:21pm  
Status: offline

beewee

Forum User
Full Member
Registered: 08/05/03
Posts: 969
Especially Geeklog.net, which is awfully slow the last months..
Dutch Geeklog sites about camping/hiking:
www.kampeerzaken.nl | www.campersite.nl | www.caravans.nl | www.caravans.net
 03/13/06 02:52pm  
Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Quote by streamer: I would like to export all email adresses from the whole user database.

phpMyAdmin can also export to CSV format, which may come in handy here.

bye, Dirk