Extract Urls from Mysql Row
<p>People go online and submit an article, with a title and description. And people often include links but they appear as basic text. I want a way in which when people include a url, it is recognized as a working link. I have written a code, but it only scans one row and doesn't seem to work in the actual table, as it is echoed outside of the table.</p>

<p>Basically...i want a table where when a link is submitted, a hyperlink is made. Any ideas?
   This updated code below keeps the same thing going on.</p>

<p>My code is below:</p>

<pre><code>      $query = "SELECT * FROM rumours ORDER BY id DESC";
     $query = mysql_query($query) or die('MySQL Query Error: ' . mysql_error( $connect ));
    while ($row = mysql_fetch_assoc($query)) {
$id = $row['id'];
$band = $row['band'];
$title = $row['Title'];
$description = $row['description'];

$reg_exUrl = "/(http|https|ftp|ftps)\:\/\/[a-zA-Z0-9\-\.]+\.[a-zA-Z]{2,3}(\/\S*)?/";

// The Text you want to filter for urls
 // Check if there is a url in the text
  if(preg_match($reg_exUrl, $description, $url)) {
   // make the urls hyper links
   preg_replace($reg_exUrl, '&lt;a href="'.$url[0].'"&gt;'.$url[0].'&lt;/a&gt;', $description);

      }

   echo "&lt;table border='1'&gt;";
   echo "&lt;tr&gt;";
   echo "&lt;td&gt; $title  &lt;/td&gt;";
   echo "&lt;/tr&gt;";
   echo "&lt;tr&gt;";
   echo "&lt;td class = 'td1'&gt; $description &lt;/td&gt;";
   echo "&lt;/tr&gt;";
   echo "&lt;/table&gt;";

}
</code></pre>
