I am doing a MySql database and I would like 12 checkboxes (corresponding to the columns) on the top, that, when checked return the db results sorted by the respective columns.
When the user clicks the first checkbox - whichever one he wishes - a number "1" appears in it, when the second checkbox is checked (any of them, in any order) a 2 appears in that checkbox, and so on through all of them.
The results results are sorted by '$Checkbox 1', '$Checkbox 2', and so on, in order...
If the user has 7 checkboxes marked and he unchecks $Checkbox 4, then $Checkbox 5,6&7 change values to $Checkbox 4,5&6.
Does this make any sense?