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/

Reply via email to