actually i started reading the php book i bought, and figured it out. it only took about 10 lines of code. anyone expecting to get paid for 10 lines of code isn't the type of person i'd want to give my money to anyways. but thanks for the info, perhaps you thought i was describing a bigger project. by the way this is the code i made to do the job:
<?php
$db = mysql_connect("XXXXXXXX", "XXXXXX", "XXXXXX");
mysql_select_db("XXXXXXX",$db);
$result = mysql_query("SELECT * FROM XXXXXX ORDER BY Name",$db);
echo "<table width=100% border=0 cellpadding=1 cellspacing=1 bgcolor=#5F5F5F>\n";
while ($r0w = mysql_fetch_row($result)) {
printf("<tr><td bgcolor=#FFFFFF><font size=2><a href=%s target=_blank>%s</a> - %s</font></td></tr>\n", $r0w[1], $r0w[0], $r0w[2]);
}
echo "</table>\n";
?>