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/