Multiple upload problem
I have a system that allows users to select a hotel then select the type of room they want and the number of days they require. (There are only 7 days as it is for a festival)
I have the hotels stored in a database and I have a list of room types and prices per day for each of these rooms. I have attached a screen shot.
I want to allow the user to select for example a twin for mon, tue and wed AND a triple for thurs and fri. The price is then stored in a database. (I have attached a screenshot of how it is stored)
I have added a repeat region which I thought would do this but it just stores all the information in one row for example if I select single monday and tuesday and a double tuesday and wednesday it stores the single price on monday the double price on the tuesday (it discards the monday single price) and the double price on the wednesday.