title: Link within PHP and Database $row
body: <p>I have hit a bump on my road and quite figure out how to get this working the way I want. I hope some of you can give me a helping hand with this!</p>
  
  <p>Currently I have a table that displays some information from my database on my website and that is working great, however I can't figure out how I make a link within my table. I need to use an external website that I can link to and at the same time use one of my $row in the link. Here is my code:</p>
  
  <pre><code>&lt;!DOCTYPE html&gt;
  &lt;html&gt;
  &lt;head&gt;
      &lt;title&gt;Store Topliste&lt;/title&gt;
  &lt;/head&gt;
  &lt;body&gt;
  &lt;h4&gt;Denne side viser dig en liste over dem der har flest Credits i Store&lt;/h4&gt;&lt;/br&gt;&lt;/br&gt;
  &lt;table&gt;
      &lt;tr&gt;
          &lt;th&gt;Rank&lt;/th&gt;
          &lt;th&gt;Navn&lt;/th&gt;
          &lt;th&gt;Credits&lt;/th&gt;
          &lt;th&gt;Steam ID&lt;/th&gt;
          &lt;th&gt;Sidst Online&lt;/th&gt;
      &lt;/tr&gt;
      &lt;?php
      $conn = mysqli_connect("HOST", "DATABASE", "PASSWORD", "USER");
      if ($conn-&gt; connect_error) {
          die("Connection failed:". $conn-&gt; connect_error);
      }
  
      $sql = "SELECT name, authid, credits, date_of_last_join from store_players ORDER BY credits DESC LIMIT 250";
      $result = $conn-&gt; query($sql);
  
      if ($result-&gt; num_rows &gt; 0) {
              $rank = 1;
          while ($row = $result-&gt; fetch_assoc()) {
              echo "&lt;tr&gt;&lt;td&gt;". $rank ."&lt;/td&gt;&lt;td&gt;" . $row["name"] . "&lt;/td&gt;&lt;td&gt;". $row["credits"] . "&lt;/td&gt;&lt;td&gt;" . "STEAM_1:", $row["authid"] . "&lt;/td&gt;&lt;td&gt;" . strftime("%d.%m.%Y %H:%M:%S", $row["date_of_last_join"]) . "&lt;/td&gt;&lt;/tr&gt;";
              $rank++;
          }
          echo "&lt;/table&gt;";
      }
      else {
          echo "0 result";
      }
  
      $conn-&gt; close();
      ?&gt;
  &lt;/table&gt;
  &lt;br&gt;
  &lt;p&gt;- Dette system er udviklet af &lt;a href="https://steamcommunity.com/id/LasBoi"&gt;LasBoi&lt;/a&gt; med ♥. &lt;/p&gt;
  &lt;/body&gt;
  &lt;/html&gt;
  </code></pre>
  
  <p>So here is a picture of what it looks like:
  <a href="https://i.stack.imgur.com/HzSLK.png" rel="nofollow noreferrer">Website Example</a></p>
  
  <p>What I want is that the STEAM_1:1:61281672 (" . "STEAM_1:", $row["authid"] . ") links to this address - "<a href="https://steamidfinder.com/lookup/STEAM_1" rel="nofollow noreferrer">https://steamidfinder.com/lookup/STEAM_1</a>:" and that the rest of the website link will be filled out by $row["authid"] so it will be a complete link to the profile on that site. And still maintain the same text structure (STEAM_1:1:61281672) that is already on my website.</p>