Welcome to Geeklog, Anonymous Sunday, December 22 2024 @ 08:39 pm EST

Geeklog Forums

export all emails?


Status: offline

jason559

Forum User
Regular Poster
Registered: 03/31/03
Posts: 83
Is there anyway to export all emails for mailing? If so, how?

Or maybe a plugin that will support emailing to all users?

Thanks
 Quote

Status: offline

DTrumbower

Forum User
Moderator
Registered: 01/08/03
Posts: 507
You could put the following code in a staticpage.
Text Formatted Code
$sql = "SELECT username, fullname, email ";
$sql .= " FROM gl_users";

$order = " ORDER BY username ASC";

$recs = DB_query($sql . $order);
$nrows = DB_numRows($recs);
$display="Emails<br>";
for ($x = 0; $x < $nrows; $x++) {
    $A = DB_fetchArray($recs);
         $display .= "<br> $A['username']   $A['fullname']   $A['email']";

}

return $display;
 


This has not been tested.
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Also, phpMyAdmin can export any fields you want to CSV.

bye, Dirk
 Quote

All times are EST. The time is now 08: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