I'm making the admin area of a hotel booking system in mysql and php, but I just can't figure out how I can select and show 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.
User can input $startdate, $enddate, $hotelid when search is made. When there is no record for a certain date (e.g there are records between 2007-04-11 and 2007-04-18 in the DB, but user searches between 2007-04-11 and 2007-04-20) 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]
I'm confused and stuck with loops and arrays.