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

Question

Hello,

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.

Answer 1

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>';

Answer 2

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.

Answer 3

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