MySQL Reservation Problem
I have a products table that has a bunch of products, and I need a query that will query another table and find out if there are any reservations for the project during a set period.
For instance, I have three things:
The boat is reserved on 2-12-07 to 2-16-07 and the others are not reserved. I need a way to do it in one query if I give to days to query another table to just see if there is a reservation for that time period.
If I type in 2-10-07 to 2-15-07 I should find the Car and Toy unreserved, but the Boat reserved. I know I can do a loop, but when I have 131 products, its alot of queries to access the database.