title: PHP/MySQL - If no rows of a certain type available, load a place holder
body: <p>So I have this query:</p>
  
  <pre><code>SELECT * FROM cars {$statement} AND deleted = 'no' AND carID NOT IN (SELECT carID FROM reservations WHERE startDate = '".$sqlcoldate."') GROUP BY model
  </code></pre>
  
  <p>It basically checks the reservations table and then if there are reservations, it gets those carIDs and excludes them from the loop.</p>
  
  <p>This is cool, so as there may be three dodge vipers and 2 are booked out it will only display the last one, and it will only display one at a time anyway because I group the results by model. </p>
  
  <p>All that is good, however when it runs out of entries, so all the cars are booked out, the car does not appear in the list of cars. (As i clear from the query).</p>
  
  <p>I would like a way to say if no rows of a certain car model are in the results, to display a placeholder, that says something like 'UNAVAILABLE'.</p>
  
  <p>Is this possible at all? Its mainly so users can see the company owns that car, but knows its not available on that date. </p>