[RESOLVED] hotel check-in check-out code

[bastienvans]

Hello,

I am working on a home rental booking website, and I am currently working on the check-in/check-out part.

check-in would be the starting date and check-out the ending date.

My 'Calendar' table is setup this way:

propertyID| month | year | days

5641 | 4 | 2010 | FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
5641 | 7 | 2010 | FFFFFBBBFFFFFFFFFFFFFFFFFFFFFFF
5641 | 9 | 2010 | FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF

Each F represents 'Free' (availability) and each B represents 'Booked'.

In a nutshell, I need a code that takes the starting date until the ending date, looks in my database if 'B' is present in any of that range.

I am not looking for anyone to write this code for me, I just need some good pointers.

Thanks!

PS: feel free to chime in regarding my calendar database. I am not sure the way I set it up is the most efficient, but it seemed the most logical at the time.

[bradgrafelman]

Why not just have a table that contains date ranges when a property is booked. Then you'd simply query the DB to see if any rows fall within your test range to determine if it was booked or not.

[bastienvans]

thanks for your reply.

This is exactly what I am doing right now... can't believe I didn't think of it earlier... I actually found the solution on this board. It's been a long day. -_-

cheers anyways 🙂