Create url link within free text
<blockquote>
  <p><strong>Possible Duplicate:</strong><br>
  <a href="http://stackoverflow.com/questions/9250216/linkify-php-text">Linkify PHP text</a>  </p>
</blockquote>



<p>Hi I have a field from a database that contains http links as well as normal text.</p>

<p>I need to find out a way to display this information using PHP to show Text and a  link when applicable.</p>

<p>the following is my sql query:</p>

<pre><code>  $sql =
   "select bw_supporting_doc
    from cm3rm2 with(nolock)
    where number = '$id'";
</code></pre>

<p>the output of this sql statement is:</p>

<p><code>Please find below the link to the FSS: http://blahblack.html</code></p>

<p>I need to display the <a href="http://blahblack.html" rel="nofollow">http://blahblack.html</a> as a link at the moment it is displaying as normal text.</p>

<p>Thanks!</p>
