title: How to pass variables from one PHP file to another using HTML links?
body: <pre><code>    //DB CONNECTION
     $sql = "SELECT `city`,`country` from infotab";
     $result = $conn-&gt;query($sql);
  
     while ($row = $result-&gt;fetch_assoc()) {
       echo  $row["city"].$row["country"]"&lt;a href='order.php'&gt;order&lt;/a&gt;"; }
  </code></pre>
  
  <p>Table output:</p>
  
  <p><img src="https://i.stack.imgur.com/mFTTB.png" alt="http://imgur.com/jH2VzBf"></p>
  
  <p>This code will select data. Additionally, there is reference to <code>order.php</code> on every line. When the user clicks on reference( <code>&lt;a href&gt;</code> clause), it opens <code>order.php</code> and there I need to know which row the user selected to work with these data.</p>