Export Email Address

Not directly from the site, but you could write a simple MySQL query that displays all addresses on one page which you can save as a text file. Or do it via Phpmyadmin, it has a more comfortable export function.

Steffen

Thanks for replying. I am very new to this process. I see the PhpAdmin Option on my server. However I am not quite sure what table I would be exporting this information from. Would you happen to know which table/database I would need to export this information from?  Thanks in advance.

The addresses are in the "email" field of the #prefix#fanfiction_authors table, where #prefix# (if applicable) is the table prefix you've defined during the installation process. But I don't know if phpmyadmin allows exporting only one field of a table.

Put this in a file in the main eFiction directory. If you have a prefix (like Steffen explained), then add it in the query. 🙂 When you visit the page, it should output a list of all email addresses, comma separated. It might take a long/short time depending on how many members you have. You might also want to delete it after it's served its purpose.

<?php
define("_BASEDIR", "");

require("config.php");

$query = dbquery("SELECT email FROM fanfiction_authors");

$emails = array();

while ($row = dbassoc($query)) {
 $emails[] = $row['email'];
}

$email_list = implode($emails, ', ');

print $email_list;

?>

Everyone..Thanks for you help. I was able do the code and the phyadmin.. The phpadmin was really easy and very helpful as was the coding.. Again .. thanks all.  😀

Zeta