how do you make something from the database a link?

philvia

I have

<td CLASS=CELL1><center><a href=".$myrow["link"].">".$myrow["linkname"]."</td>

say the link is www.phpbuilder.com, on the page it shows the link as http://my site/www.phpbuilder. How do I get it to say just www.phpbuilder.com?

laserlight

$myrow["link"] should contain "http://"

leatherback

Hi,

Doesn't really make sense this way.

I think you have to check wether the quotes are not messing things up.

BEsides that: You need to place a </a> tag after .$myrow["linkname"]."

laserlight

You might use something like:

echo '<td style="text-align: center;" class="CELL1"><a href="' . $myrow['link'] . '">' . htmlspecialchars($myrow['linkname']) . '</a></td>';

though again the link URL must have "http://"

Norman_Graham

... what you need in your database (among other things) is:

link varchar (255)
linkname varchar (255)

and then:

INSERT INTO mylinks VALUES (
"http://www.phpbuilder.com", "PHP Builder"
);

and then use the line that Laserlight has shown you. From the code you posted, Philvia, it looks like you're wandering from HTML to PHP without initiating the PHP with the <?php ?> tags. Certainly the syntax wasn't going to work if what you posted was an echo statement.

Best of luck

Norman

PS: If you can be sure that the data in the DB has no extra spaces, fine. Otherwise, consider using trim() for the actual link to ensure that it works.