title: music from PHPMyAdmin to play in a modal box
body: <p>I am trying to  to put a music from my table in phpmyadmin into a modal box. I have been able to have them in a modal box but it puts all of them in and I only want the specific music allocated to a specific button to play.</p>
  
  <p>Here is my code:</p>
  
  <p>audio.php</p>
  
  <pre><code>&lt;?php
  
  /*the variables*/
  $servername = "localhost";
  $username = "root";
  $password = "";
  $dbname = "arashi_site";
  
  $conn = mysqli_connect($servername, $username, $password, $dbname);
  
  if (!$conn) {
      die("Connection failed: " . mysqli_connect_error());
  }
  /*sql to extract the data*/
  $sql = "SELECT * FROM music";
  $result = mysqli_query($conn, $sql);
  /*condition to see if there are any results*/
  if (mysqli_num_rows($result) &gt; 0) {
  /*a loop function to output */
       while($row = mysqli_fetch_assoc($result)) {
  /*echos the data within each column*/
           /*within the final &lt;td&gt;, audio controls will be echoed to play the song files. When the user clicks any of the buttons in the audio controls, they will remain in the second section the the site and not be sent back to the top.*/
     echo "&lt;button type='button' class='btn btn-info btn-lg' data-toggle='modal' data-target='#myModal'&gt;" . $row["song_name"] . "&lt;/button&gt;";
     }
     }
  
  
   else {
      echo "0 results";
   }
  
  mysqli_close($conn);
  
  ?&gt;
  </code></pre>
  
  <p>audio2.php:</p>
  
  <pre><code>&lt;?php
  /*the variables*/
  $servername = "localhost";
  $username = "root";
  $password = "";
  $dbname = "arashi_site";
  
  $conn = mysqli_connect($servername, $username, $password, $dbname);
  
  if (!$conn) {
      die("Connection failed: " . mysqli_connect_error());
  }
  /*sql to extract the data*/
  $sql = "SELECT song_name FROM music";
  $result = mysqli_query($conn, $sql);
  /*condition to see if there are any results*/
  if (mysqli_num_rows($result) &gt; 0) {
  /*a loop function to output */
       while($row = mysqli_fetch_assoc($result)) {
  
   echo "&lt;audio id='sound' controls&gt;
          &lt;source src='audio/" .$row['song_name']."' type='audio/mpeg'&gt;
                      Your browser does not support the audio element.
     &lt;/audio&gt;";
  }
  }
  
  else {
      echo "0 results";
   }
  
  mysqli_close($conn);
  
  ?&gt;
  </code></pre>