title: Website to display and filter data from MySQL Database
body: <p>I need to create a website to display some information from a MySQL Database on the same server, but have no idea where to start.</p>
  
  <p>I have a:
  MySQL Database. This contains one table with information on items which were added on a particular date. Information includes, Title, Location and Date the item was added.</p>
  
  <p>I need to:
  Create a website front end which will allow me to filter by a particular date and display the Title and Locations of all devices which were checked on that date, preferably in a table format.</p>
  
  <p>I am also currently running an Apache/PHP/MySQL web server on the same machine and know how to return data via JSON using PHP, but have no idea how to manipulate it into website format?</p>
  
  <p>I assume I would start by allowing the user to select from a list of avaliable dates somehow, then use their selection to perform a "SELECT * FROM 'added_devices' WHERE date=?", which then returns {"Title":Bob,"Location":London,"Date":20/11/03}, {"Title":Bill,"Location":Manchester,"Date":18/12/05}, </p>
  
  <p>Any help would be greatly appreciated, no idea where to start!</p>