I need a simple one page script that selects and shows rooms in a calendar style (see here: [url removed, login to view]). Text boxes show the value of column "rooms" from "avail" table, that is the number of rooms available for that day for that type of room.
It should always display 2 weeks with Saturday and Sunday columns showed in another color. User can enter starting date ($startdate) and $hotelid when search is made. When there is no record for a certain date in the DB, text boxes should still appear with a value "-1".
I would also like to update the calendar.
For sql stucture: [url removed, login to view]