Fairly new to Joomla development. Put a folder called Forms in model folder to load the necessary JForm data. Everything is working fine but I need to grab data dynamically from the database to populate a drop down box.

    <field name="category"
        type="list"
        label="Item Category"
        description="Item Category"
        class="inputbox"
                >
        <option value="1">
            Data from database</option>
        <option value="2">
            Data from database</option>
        <option value="3">
            Data from database</option>
    </field>

The above is a rough example. I want the values and option names to come from a database. Do I use a JTable or params and if so how? I much appreciate any help. Thanking you all.

xml forms joomla
Edit
Report