forum.coppermine-gallery.net

Support => cpg1.3.x Support => Older/other versions => cpg1.3 Ecards & Email => Topic started by: Rafael_XCX on August 12, 2006, 08:55:39 am

Title: E-mail PHP list modifications?
Post by: Rafael_XCX on August 12, 2006, 08:55:39 am

Hi! Please, I saw a code you guys did here for someone to list all the registered e-mails:

Code: [Select]

<?php

define('IN_COPPERMINE', 1);
require 'include/init.inc.php';

$test = db_query("SELECT DISTINCT(user_email) FROM {$CONFIG['TABLE_USERS']} WHERE user_email <> ''");

while ($row = mysql_fetch_assoc($test))
echo $row['user_email'] . "<br />";

?>
Can you please adapt it to show the username, e-mail and location? Like this:

John
john@hotmail.com
England

Bob
bob@hotmail.com
USA

....

Can you please post the code here?