I need help with a rather complicated query to a MySQL database. We have 4 laptops here at work that we loan out. I want to create an online scheduler/calendar that shows who has those laptops and the times they have them.
The problem comes, when I created an HTML form for people to request a laptop, I need to have the code check to see if that laptop is already reserved or not. But what kind of query could check to see if the laptop was already reserved?
Say they want laptop A from 3pm-8pm on Friday. How would I structure my query to check if that timeslot was open?
Thanx
The problem comes, when I created an HTML form for people to request a laptop, I need to have the code check to see if that laptop is already reserved or not. But what kind of query could check to see if the laptop was already reserved?
Say they want laptop A from 3pm-8pm on Friday. How would I structure my query to check if that timeslot was open?
Thanx