|
|
Posted by not_on on 10/31/05 00:26
I have X amount of hotel rooms stored in hotel table. mutiple hotels
each with mutiple rooms so hundreds of entries.
I need to store booking dates for every room with one year in advance.
I am trying to get my head around best method
Each room with 365 columns?
or
365 columns witha list of rooms booked that date.. hmm mebbe not
or
TEXT collumn in theroom table. this holds a list of dates stored as
such 4,67,85,199,345 each number= a day of year .. then I can split
the string (PHP) and plonk into online calander. One text field for
each room rather than 365 columns multiplied by number of rooms.
Any other ideas or best practice.. advice? :)
Navigation:
[Reply to this message]
|