Let me give you guys a brief description of what I'm working on.
- 11 houses that are to be rent out between the remainder of 2007, until 2025.
- Users must be able to load up a website, view a calender and see when the houses are availible to be rented out.
For example, user loads the webpage, selects the house he is interested in, loads up the appropriate month and year, and can see if the house is availible for rent.
This must work of SQL, I can't seem to think of any other options but to do the following:
- One table per house per year, this would lead up to more then 150 tables, I don't think this is very acceptable.
Any idea is helpfull.
PHP Calender + SQL
Moderator: General Moderators