title: How do I filter items listed on a page using a MySQL query without refreshing the page?
body: <p>I have a page which generates an audio playlist from tracks in a MySQL database using a select query, i.e.</p>
  
  <pre><code>$query1="SELECT * FROM tracks WHERE uploaded_page='$this_path_short' ORDER BY id DESC";
  </code></pre>
  
  <p>I would like the user to be able to filter the playlist in various ways, and the plan is to have a series of radio buttons in a form that will generate a new MySQL query to list just the required tracks.</p>
  
  <p>I would like to know the best way of updating the playlist with this query.  Ideally this would be done without refreshing the page.</p>