URL Link from HTML form to PHP page
<p>I have read a lot of submissions, I haven't been able to find an answer to my exact question. </p>

<p>I am filling out an HTML form that is sent into mysql database - I am good there. </p>

<p>The results are displayed using php in a html table. I would like the website URL to show as a hyperlink. Everything I do results in an error. </p>

<p>Does anyone know how I can update my code to allow for the website url to show as a hyperlink?</p>

<pre><code>[$dbname = "seller";

 // Create connection
 $conn = new mysqli($servername, $username, $password, $dbname);
 // Check connection
 if ($conn-&gt;connect_error) {
     die("Connection failed: " . $conn-&gt;connect_error);
} 

$sql = "SELECT website, url, price, name, email FROM listing";
$result = $conn-&gt;query($sql);

if ($result-&gt;num_rows &gt; 0) {
     echo "&lt;table&gt;&lt;tr&gt;&lt;th&gt;Website&lt;/th&gt;&lt;th&gt;URL&lt;/th&gt;&lt;th&gt;Price&lt;/th&gt;&lt;th&gt;Contact      Name&lt;/th&gt;&lt;th&gt;Email&lt;/th&gt;&lt;/tr&gt;";
     // output data of each row
     while($row = $result-&gt;fetch_assoc()) {
         echo "&lt;tr&gt;&lt;td&gt;" . $row["website"]. "&lt;/td&gt;&lt;td&gt;" . $row["url"]. "  &lt;/td&gt;&lt;td&gt;" . $row["price"]. "&lt;/td&gt;&lt;td&gt;" . $row["name"]. "&lt;/td&gt;&lt;td&gt; " .    $row["email"]. "&lt;/td&gt;&lt;/tr&gt;";
     }
     echo "&lt;/table&gt;";
} else {
     echo "0 results";
}

$conn-&gt;close();
?&gt;]
</code></pre>

<p>Thanks</p>