Member Avatar for Yna Aurielle

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
0fac31edf20c874089f52ed4a0be4fb6

  • 3 Contributors
  • 2 Replies
  • 372 Views
  • 5 Hours Discussion Span
  • Latest Post Latest Post by Reverend Jim

Recommended Answers

All 2 Replies

Member Avatar for Begginnerdev

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.

Member Avatar for Reverend Jim

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.