The purpose of this project is to write the coding for populating up to 7 dropdown boxes that will allow the user to select/view a final code.
The data are contained in a single mysql table and selection are made from each column. selection from 'column1' filter selection for 'column2' that filter selection for 'column3', etc... The final selection is a product code that is unique.
A sample table is attached in txt format.
The first choice is country, then region, then area0.... up to area3 (max 6 criteria).
the final output is the code which is dependant to the last possible selection. IMPORTANT: some rows have 6 creteria, some have less thus the 'code' dropdown output must be populated for each successive selection starting from 'region' (in other words, it is possible that area2 for ex. is empty but the code must be selected.
Each dropdown box population should be done without 'refreshing' the page.
Note: the full database table is more than 3000 lines. Thus there must be a cncern as well on speed of execution.