If your DB has the name, link stored in it then just select both columns and then output them to your HTML formatted output. Small example: $sth=$dbh->do("select player, link from hockeylist"); print qq!<a href="$link">$player</a>!; -----Original Message----- From: Simon K. Chan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 03, 2001 1:33 PM To: [EMAIL PROTECTED] Subject: links Hey Everybody, I have an online database where I use a CGI script that uses the DBI to return the values from Mysql. How do I return a link? For example, if I have a database for hockey players, and I return the name "Wayne Gretzky." Is there a way to make that a link that will go to say, NHL.com ?? Where would I insert the html tag <a href="http://www.nhl.com">Wayne Gretzky</a> ?? Many thanks. simon ===== ######################################### Simon K. Chan [EMAIL PROTECTED] "Great spirits have always encountered violent opposition from mediocre minds." -Albert Einstein __________________________________________________ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/