Here's what I am trying to do.
I want to create a form with various rooms, times and details. I want people to be able to book those rooms and times. I want to display their booked information on the site. Once the date of their booking passes, I want it removed from the page/post.
Creating a form to collect these details is easy, having people submit details is also easy.
Here are the things I am having trouble with:
#1 - How do I make it so that they can't book the same room at the same date and time. They can book it before or after the conflicting booking.
#2 - How do I get this information and display it.
#3 - Based on how I display the information, I should be able to filter out "old" information (without removing it from the database).
Anyone have any thoughts or ideas?