displaying words from db as links in php

Question

i have words like 123.com , 234.org in database how to display them as links?

<?php
$con=mysql_connect("localhost","root","123");
mysql_select_db("www",$con);

$result=mysql_query("SELECT * FROM Tag");

for ($c=0; $c< mysql_num_rows($result); $c++)
{
$f=mysql_fetch_array($result);

###########echo $f['name']." ";
}
 mysql_close($con);
?>

Gavin H · Accepted Answer · 2010-08-25 14:51:49Z

2

You need to output the HTML for a link. Something along the lines of:

print "<a href=\"" . $url . "\">" . $f['name'] . "</a>";

replacing url with the site URL you want the link to go to. It sounds like it might also be $f['name'].

answered Aug 25, 2010 at 14:51

Gavin H

10.5k3 gold badges38 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Brian Ray · Accepted Answer · 2010-08-25 14:52:01Z

0

echo '<a href="'.$f['name'].'">'.$f['name'].'</a>';

answered Aug 25, 2010 at 14:52

Brian Ray

1,4913 gold badges20 silver badges20 bronze badges

Comments

Mike · Accepted Answer · 2010-08-25 15:06:44Z

0

This should work:

$result=mysql_query("SELECT * FROM Tag");

while($f=mysql_fetch_array($result)){
    echo "<a href='" . $f['name'] . "'>" . $f['name'] . "</a>";
} 
mysql_close($con);
?>

A link in html code looks like this:

<a href="123.com">123</a>

The php you are using only outputs this to html:

123.com

edited Aug 25, 2010 at 15:06

answered Aug 25, 2010 at 14:57

Mike

2,91010 gold badges44 silver badges57 bronze badges

Comments

j0k · Accepted Answer · 2012-08-22 16:20:46Z

0

links are html.

echo '<a href="'.$f['name']'.">Click me</a>';

edited Aug 22, 2012 at 16:20

j0k

22.8k28 gold badges81 silver badges90 bronze badges

answered Aug 25, 2010 at 14:53

Leon

8796 silver badges8 bronze badges

Collectives™ on Stack Overflow

displaying words from db as links in php

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related