Hi all, I seem to be having a couple of issues with a query. For some reason, it fetches random orders instead of those with the product_id = 2. Not to sure why this is happening. This is part of a booking system but is proving very frustrating! Any help would be hugely appreciated :)
There seems to be a problem with the dates, for when I remove the dates BETWEEN it works, but I need the dates to grab the correct availability.