Anywhoo,
I think you could adapt this code pretty well...
if(!($link_id = mysql_connect($Host, $User, $Pass))) die(mysql_error());
mysql_select_db($DB);
$sql = "SELECT * FROM " . $Table . "";
if(!($result = mysql_query($sql))) die(mysql_error());
while ($myrow = mysql_fetch_assoc($result)) {
printf("<table><tr><td>Name: %s </td> <td>Password: %s</td></tr></table>",
$myrow['Name'], $myrow['Password']);
}
Ok, so, the bit at the top obviously handles mysql database, so change the variables host, user, pass and table to whatever or set them as whatever...
Basically what I've done with printf is done a repeater, so for every row I have in my db it creates a table with 1 row and 2 cols and fills the %s with the entry from left to right, so...
<table><tr><td>Name: %s </td> <td>Password: %s</td></tr></table>
Will end up showing, a name in the left column and the password in the right column, change those as necessary, those are obviously the field names.
$myrow['Name'], $myrow['Password']
Just sets the order of what the %s would be replaced with, by changing those around I could have password in the left column (or wherever I place the second %s in the repeating html) and name in the right, anyways, I think you get the idea...
What you need to do, is create a table for just that, email and name, so your printf() would look something like this....
printf("<a href=mailto:%s>%s</a><br>", $myrow['Email'], $myrow['Name']);
It would then print out like this...
Mark
Frank
Joe
Each clickable with a mailto:
Hows that for ya? got enough to work with?
