title: Checking product stock against a date
body: <p>Excuse my lack of knowledge! I'm working on a system (PHP &amp; MySQL) that will allow customers to rent machinery. It allows users to sign up, enter details about their job (location, job duration/dates), browse machinery/other products, add products to their basket and confirm the hire. The booking will be processed by an employee and the machinery/products will be delivered to the customer on the date specified. The system isn't required to process payments as invoices will be issued upon delivery.</p>
  
  <p>I have a products table in the database that includes the name, description, image, stock_quantity and daily_price.</p>
  
  <p>I also have a hire table that includes customer_id, start_date, end_date etc.</p>
  
  <p>I want to be able to check to make sure products are available on specified dates to avoid double booking.</p>
  
  <p>How would I go about this?</p>
  
  <p>Thanks in advance.</p>