MySQL database Links to HTML Table : <p>I am trying to learn more about html, php, and mysql. I am trying to retrieve a link from the database that is just stored as a varchar, then display it in a table.</p>

<p>Each entry will have a different link, they are all linked to external website and I couldn't figure this out.
Here is my current code.</p>

<p><div class="snippet" data-lang="js" data-hide="false">
<div class="snippet-code">
<pre class="snippet-code-html lang-html prettyprint-override"><code>&lt;?php

include("connection.php");
        
$sql = "SELECT Username, Location, Points FROM database ORDER BY Points DESC";
$result1 = mysqli_query($db_con, $sql);  

while($row1 = mysqli_fetch_array($result1)):;?&gt;

  &lt;tr&gt;

  &lt;td&gt;&lt;a href="'.$row['Location'].'"&gt;&lt;?php echo $row1[0]; ?&gt;&lt;/a&gt;&lt;/td&gt;
  &lt;td&gt;&lt;?php echo $row1[1]; ?&gt;&lt;/td&gt;
  &lt;td&gt;&lt;?php echo $row1[2]; ?&gt;&lt;/td&gt;
                                        
  &lt;/tr&gt;
&lt;?php endwhile; ?&gt;
						
&lt;?php</code></pre>
</div>
</div>
</p>

<p>The Location is where the links are stored, as you can tell I had a fairly sad attempt as I don't know mysql, php to well.</p>

<p>Thanks for your time!</p>
