First off, I am not entirely sure how to word this question so maybe this is a duplicate(?). If so, I haven't found the other one and sorry in advance.
I am working on an application where the user can select multiple resources within a certain time frame. Something like room and group.
When verifying this I need to be sure no group or room is selected twice within the same time frame.
I am a bit unsure as to how I can make sure nothing is selected twice within the same time frame and keeping the application snappy.
I am using PHP7 and MySQL