Welcome to Geeklog, Anonymous Monday, May 20 2024 @ 07:57 am EDT

Geeklog Forums

export email adress


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

Status: offline


Forum User
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';



perfect! thx for your fast help, kr!!

Status: offline


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.

Status: offline


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

Status: offline


Site 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

All times are EDT. The time is now 07:57 am.

  • 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