Welcome to Geeklog, Anonymous Monday, March 18 2024 @ 11:39 pm EDT

Geeklog Forums

export email adress


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
 Quote

Status: offline

kr

Forum User
Newbie
Registered: 03/02/06
Posts: 4
Location:Germany
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';


 
 Quote

streamer

Anonymous
perfect! thx for your fast help, kr!!
 Quote

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.
 Quote

Status: offline

beewee

Forum User
Full Member
Registered: 08/05/03
Posts: 969
Location:The Netherlands, where else?
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
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
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
 Quote

All times are EDT. The time is now 11:39 pm.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content