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
Yna Aurielle 0 Newbie Poster
Begginnerdev 256 Junior Poster
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.
Reverend Jim 5,224 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster
The thread identified it as mysql.
Begginnerdev 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.