I am a total noob in coding. Back in engineering school we had some coding classes and I was good at it but I never really focused on that. I know some python and c# and that is about it.
I have a site. I use Cpanel and used Joomla to build the site.
In this site, certain users have "player" access. These users, every week, need to select an option from a form, and this option they can never select again. The game lasts 17 weeks, and by week 17, all of them are left with only two options which are then automatically selected, given that they always selected an option in the previous weeks, else they have to choose 2 out of the "many" options they could have.
Currently, I am using visforms to create a form where I have a dropdown list and they can select the option for that week. My problem is that, I cannot make that list dynamic. Meaning that they are always presented with all the options no matter what week we are in and what options they have selected before. Also, it is the same list for all users, it does not eliminate the option that they have already selected in previous weeks.
What I want to do is stop using visforms and create a form myself. I think I can figure out how to create a drop-down list in html with all the options needed. What I do not know is the following:
Whatever the user selects in that drop-down list, store it in an SQL database that I have created in CPanel. And store it based on each user. Make the drop-down lists user dependent. Meaning that the options shown are based on the user that is seeing them. Because if they have selected an option before, I do not want them to have that option available anymore. And it is different for every user, of course. Please point me in the right direction to solve my problem. I will do my due diligence and most likely come back in a future date with some questions but also with some code.