-----Original Message-----
From: Gary H. Holabird [mailto:[EMAIL PROTECTED] 
Sent: Thursday, October 02, 2003 11:06 AM
To: [EMAIL PROTECTED]
Subject: Hyperlinks in MySQL dB

This has got to be really simple & I feel really stupid having to ask
but...

I'm a very green n00b writing my first php script.

I have a VERY simple MySQL table which I would like to display a bunch
of
hyperlinks (one hyperlink per row) but I dont want the user to see the
actual webpage addresss. eg: a field will say, for instance, Title1, but
when the user clicks on it they will be directed to the page or document
described in the link.  I'm sure everybody knows how to do this.

Also, attempting the same thing, but on an Intranet with web addresses
of MS
Word docs on the network.

Thanks tons in advance.

$sql = "Select link, linktext from table";
if(!$result = mysql_query($sql)) {
        //error handling code here
}
while($row = mysql_fetch_array($result)) {
        extract($row);
        echo("<a href='$link'>$linktext</a><br>");
}

I did not test this code.

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to