How to turn PHP echo statement into a PHP LINK for MySQL

Question

I am trying to turn something I requested from a MySQL table into a 'link', which is also saved in the table. Therefore, in the code below, I am trying to turn 'fldFullName' into the 'ProfileURL', both which are in the same table. After that, I should be able to click on the Full Name, say maybe John Smith, and it should take me to the link provided in the MySQL table, say http://www.domain.com/page.php?id=001313 maybe. How can I do this properly?

             {  
             echo '<span id="guest">' . $row['fldFullName'] . '<a href="' . $row['ProfileURL'] .'">'. $row['ProfileURL'] . '</a></span><br />';
             }

Thank you in advance.

Dagg Nabbit · Accepted Answer · 2010-07-15 22:12:09Z

2

echo "<span id='guest'><a href='{$row['ProfileURL']}'>{$row['fldFullName']}</a></span><br />";

answered Jul 15, 2010 at 22:12

Dagg Nabbit

77k19 gold badges115 silver badges142 bronze badges

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

Comments

2ndkauboy · Accepted Answer · 2010-07-15 22:16:41Z

1

Your problem is, that the full name is not within the Tag. So correct you code to something like this:

echo '<span id="guest"><a href="'.$row['ProfileURL'].'">'.$row['fldFullName'].'</a></span><br />';

If you still want the ProfileURL visible, you can also include it within the tag.

edited Jul 15, 2010 at 22:16

answered Jul 15, 2010 at 22:11

2ndkauboy

9,4033 gold badges34 silver badges67 bronze badges

Comments

Mike Rifgin · Accepted Answer · 2010-07-15 22:19:33Z

0

If i'm understanding you correctly then you were very close.

This gives you the Fullname as a link which then links to the address provided by the profileURL field:

 echo '<a href="' . $row['ProfileURL'] .'">' . $row['fldFullName'] . '</a>';

edited Jul 15, 2010 at 22:19

answered Jul 15, 2010 at 22:07

Mike Rifgin

10.9k22 gold badges78 silver badges115 bronze badges

3 Comments

2ndkauboy Over a year ago

That will only print the text of the full name but no link at all. And there are even many errors in you code. Remove the quotation marks and dot before and after the var from the array. But even than it's only the text and no link.

Mike Rifgin Over a year ago

Sorry new ot this site...forgot to wrap my code in code tags :(

2ndkauboy Over a year ago

Better but even not perfect. You are still missing a quotation marks after the closing bracket of the opening tag of the link. and you have removed the span with the id which might be needed. Just copy the rest of my answer and you are right ;)

Collectives™ on Stack Overflow

How to turn PHP echo statement into a PHP LINK for MySQL

3 Answers 3

Comments

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related