MyBB Community Forums

Full Version: Exporting email addresses.
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Pages: 1 2
I create a new php file, called newsletter and I link it and copy all email address. I think it's better.

But if I was export username and email?
^ you can try using code like below
<?php
define("IN_MYBB",1);
include("global.php");
$result = $db->query("SELECT * FROM ".TABLE_PREFIX."users");
while ($row = $db->fetch_array($result)) {
echo $row['username'].' &rarr; '.$row['email'].'<br />';
}
?>
sorry again, for separator it's better a "," not an arrow
(2015-04-17, 03:17 PM)caygri Wrote: [ -> ]sorry again, for separator it's better a "," not an arrow

Replace &rarr; with a comma in the code (you'd probably want to remove the whitespaces around it as well).
Works great, thanks !
I found problem with copy&paste to Mailchimp and MailUp...it's view like one and unique row...it's possible to create a little table?
Pages: 1 2