What is the easiest way to have a dropdown / listbox to be able to select an option from a custom database table. I realise there is the select binding for template variables but I would like to have a simple snippet to create a dropdown / listbox for use in a form. I am currently exploring using FormIt to create the form and store data in my custom table.
The reason behind the question is that I want to have a form to create “players” to a custom table and I want the facility to query the custom table and check that the “player” is not duplicated and also to either create a new “player” or amend an existing “player”.
I am not experienced at php coding nor familiar with Migx, so any examples would be appreciated even if the example use these codings as I may be able to use them to understand them better.