insert multiple depend on prev queries
This problem can easily be solved by php...
Get the number of rooms selected from the first query and assign it to a variable and then loop the second query by the number of rooms choosen.