Brain Teaser

[maskme]

Dear All

I've a very complicated situation here.

In my MYSQL database I've two fields which holds integer value. The fields name are
FromDate (can hold values such as 1,2,3.....30)
ToDate (can hold values such as 1,2,3.....30)

In my HTML form I've a selection menu FromDate and ToDate

So if a person selects in HTML form the FromDate and ToDate and presses submit, and then if the FromDate and ToDate is within the Date range of database FromDate & ToDate, it should pop up the message that the Room is reserved.

So how do i do this in MySQL query itself. Its very confusing as I'm not sure how to do this.

Please help
Thanks

[Piranha]

SELECT * 
FROM table 
WHERE NOT (table.fromdate >= $todate
           OR table.todate <= $fromdate)

If it returns something the room is reserved at least one of the days. If it does not return something it is not reserved.

[maskme]

thank u Piranha, it really helped, thanks a lot 🙂

[Piranha]

Np, I had the same problem about a week ago and it can mess things up a bit.