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]
Recently someone from experts-exchange helped me with a similar problem. I had to modify the script to suit the current task but without much success. I attached this script, please check it. It doesn't work the way I want but getting close... I would like to have a simple solution. Thanks.