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.

you have a repeat region inside the repeat selection. that was added by the multiple update behavior.

you need to remove the repeat region, only the repeat selection behavior is needed.

I have removed the repeat region and left the repeat selection but now it doesn't repeat. I have attached a screenshot and the file.

I have fixed it. I did need both repeat regions I just needed the repeat selection to be inside the repeat region. I had it the other way around before.

I have another question. I only want the record to be inserted if the user selects a particular day on a room type for example if the user selects a single room on Monday and Tuesday and a double room on Tuesday and Wednesday - I only want those 2 records to be inserted - I don't want the triple room and the quadruple room to be added (with blank values). I can get it to work by adding a checkbox with the room type as the value and then on the multiple insert it only inserts if the checkbox is ticked ($WA_insertIfNotBlank = "Occupancy";). The problem with this is that often the user is just selecting the days and not ticking the roomtype check box. Is there a way that I can say if (MonTotal OR TueTotal OR WedTotal OR ThurTotal OR FriTotal OR SatTotal OR SunTotal) is not empty
insert the record.

So instead of:
$WA_insertIfNotBlank = "Occupancy";

It would say something like:
$WA_insertIfNotBlank = "(MonTotal || TueTotal || WedTotal ||ThurTotal || FriTotal || SatTotal || SunTotal)";

no, there is not a way to insert the record if if any of the days are ticked, they must select the occupancy as well.