E-mail PHP list modifications?

[Rafael_XCX]

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

Code Select Expand

<?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?