SMF 2.0:
<?php
require_once('SSI.php');
echo '
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"><head>
<title>Email</title>
</head>
<body>';
$request = $smcFunc['db_query']('', '
SELECT email_address, id_member
FROM {db_prefix}members
ORDER BY id_member',
array()
);
$members = array();
while ($row = $smcFunc['db_fetch_assoc']($request))
{
// Build the array.
$members[] = array(
'email' => $row['email_address']
);
}
$smcFunc['db_free_result']($request);
foreach ($members as $member)
{
echo $member['email'], '<br />';
}
echo '
</body>
</html>';
?>SMF 1.x:
<?php
require_once('SSI.php');
echo '
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"><head>
<title>Email</title>
</head>
<body>';
$request = db_query("
SELECT emailAddress, id_member
FROM {$db_prefix}members
ORDER BY ID_MEMBER", __FILE__, __LINE__);
$members = array();
while ($row = mysql_fetch_assoc($request))
{
// Build the array.
$members[] = array(
'email' => $row['emailAddress']
);
}
mysql_free_result($request);
foreach ($members as $member)
{
echo $member['email'], '<br />';
}
echo '
</body>
</html>';
?>