Seasonal Pricing for a Hotel Room

Posted by Laykes on Stack Overflow See other posts from Stack Overflow or by Laykes
Published on 2011-01-18T00:38:40Z Indexed on 2011/01/18 0:53 UTC
Read the original article Hit count: 150

Filed under:
|
|

I am trying to manage seasonal prices for hotel rooms.

The only way that I can think of doing it would be to use:

| DayDate   |EndDate   |  A  |  B
-----------------------------------------------
| 2010/07/1 |2010/07/2 | 200 |  40
| 2010/07/3 |2010/07/4 | 150 |  40
| 2010/07/5 |2010/07/5 | 150 |  50
| 2010/07/6 |2010/07/7 | 200 |  50
| 2010/07/8 |2010/07/9 | 100 |  60

etc.. (table taken from another question).

The problem is: I don't want my seasons to be year specific. Seasons for rooms shouldn't change year on year. I don't want my users to have to enter the seasonal information several times.

I am also going to have thousands of rooms, so I don't know a way to make this easily manageable.

I'm using mysql and php.

© Stack Overflow or respective owner

Related posts about mysql

Related posts about php5