not sure what you mean about having a 'live' email address, but to generate a link to a user's password, use this
$sql = "SELECT * FROM Users";
$result = mysql_query($sql);
$numrows = mysql_numrows($result);
for($i = 0; $i < $numrows; $i++) {
$email = mysql_result($result, $i, "Email");
$username = mysql_result($result, $i, "Username");
print "<a href=\"mailto:$email\">$username</a><br>\n";
}
if i've got the wrong end the PHP like stick, let use know and post a bit more about your problem
dom
🙂