Hi All,
This one is a bit complex, so I'll try to be as logical explaining the issue as humanily possible.
ASP/VBScript/MySQL
Issue: Creating dynamic variables while there is an unknown constant
Example: Somebody uses a drop down menu to select the type of fruit. Let's say they select apples. Now directly underneathe, a table of checkboxes is returned with all the possible results (chkbx1 = granny's, chkbx2 = smith, chkbx3 = mcintosh, and so on). The possible chkbx's are contained within a MySQL table - retrieving/displaying them is no issue. But now, each of those checkboxes must have a separate variable attached when they are called through a DO WHILE...LOOP.
ie: chkbx1, chkbx2, chkbx3, etc.
However, if someone decided to choose a different fruit, and it produced 10 results with checkboxes, it would need to dimension 10 variables. This can vary for a variety of different selections - and while we know how many are in the database, we won't know which selection from the dropdown is going to be made - and not wanting to write unique code for each of the possible scenarios - I figure there must be an easier way.
I thought of running a self-adding interger in the loop to identify them - but I don't know how to actually dimension them before hand like this...and then know this amount so I can later check the boolean results of each.
If this makes sense and you can assist, I'd be greatful.
Thank you,
Jeremy