i am making a reservation system and i am having a a problem with time conflicts(the system must not accept a reservation where in there is already an event reserved art that time. . my table looks like this

Recommended Answers

All 2 Replies

What database backend are you using?

If it is SQL, you can look for the dates using a select - between statement:

"SELECT Count(*) As Count From Table1 WHERE (Date1 BETWEEN '" & Date1 & "' AND '" & Date2 "') OR (Date2 BETWEEN '" & Date1 "' AND '" & Date2 & "')

Just check the value of Count on the return and prompt your user if there is a reservation in that time period.

The thread identified it as mysql.

commented: I'm a blonde, you have to spell it out in the sand! :) +9
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.