Topic: Complicated problem
Here is my issue !!!
I have a table called student with fields
name level choice1 choice2 choice3 ....... til choice10
and another table called classes with fields and max quantity
class1 class2 ....till 10
max10 max7
I want to reorder and insert all of the data based on the level from level1 ......til 100
I mean student-level one has the chance to get his choice ignoring the limit and when the classroom status change to max the next student will get the second choice automatically
I hope I cleared my idea