Get query results into an array

[bpj]

Have you considered using the JSON data type that was recently added?

Using JSON Database Fields to Store Multiple Choices

Intro You can use a JSON field in your database to store multiple choices like multiple checkbox or select values. In our example we will show you how to setup your database JSON field and how to generate an insert record form which will automatically create your checkboxes and their values and handle multiple value insert. Creating a JSON Database Field First let’s create a JSON field in our database table. Open the Database Manager: [Screenshot_2] We have a table storing our products: […