title: View details of table row through ID
body: <p>I have a table that displays a concert tour name, year and a view info link that is supposed to take the user to information about the specific tour using it's ID. Here's a snippet from it:</p>
  
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>while($row=mysql_fetch_array($result, MYSQLI_ASSOC)){
      echo "&lt;tr&gt;&lt;td&gt;";
      echo $row['Tour_Name'];
      echo "&lt;/td&gt;&lt;td&gt;";
      echo $row['Year'];
      echo "&lt;/td&gt;&lt;td&gt;";
      echo "&lt;a href=all_shows.php?id=".$row['ID']."'&gt;View info&lt;/td&gt;";
      echo "&lt;/tr&gt;";
      }</code></pre>
  </div>
  </div>
  </p>
  
  <p>I believe this works since the correct ID comes up in the URL when directed to the new page, but it comes out blank. I can't seem to get the information in my show_info table to appear. I've tried so many different things and I've hit a brick wall at this point. Extremely new to all of this so any help would be appreciated, thanks! :)</p>
  
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>&lt;html&gt;
  &lt;head&gt;
  &lt;title&gt;Show Details&lt;/title&gt;
  &lt;body&gt;
  &lt;?
  
  @ $db = mysql_pconnect("localhost","medinasa","");
  
  if (!$db)
  {
   echo "ERROR: Could not connect to database.  Please try again later.";
   exit;
  }
  mysql_select_db("medinasa_shows");
  $id = $_GET['ID'];
  $query_string = "SELECT * FROM show_info WHERE ID = '$id'";
  $query = mysql_query($query_string);
  ?&gt;
  &lt;h3 class="box-title"&gt;User Details&lt;/h3&gt;
  &lt;?    
                while($row = mysql_fetch_assoc($query)){
                    echo "&lt;h1&gt;".$row['Tour_Name']. "&lt;/h1&gt;";
                    echo "&lt;h1&gt;".$row['City']. "&lt;/h1&gt;";
                    echo "&lt;h1&gt;".$row['Year']. "&lt;/h1&gt;";
                    echo "&lt;h1&gt;".$row['Headliner']. "&lt;/h1&gt;";
                    echo "&lt;h1&gt;".$row['Opener']. "&lt;/h1&gt;";
                    echo "&lt;h1&gt;".$row['Comments']. "&lt;/h1&gt;";
                }    
   ?&gt;
  &lt;/body&gt;
  &lt;/html&gt;</code></pre>
  </div>
  </div>
  </p>