Best way to add data into database

Wappler General Need Help
1

I would like to have multiple inserts into one row on a table in the database, for example.
Modules (1,2,3,4,5)

Obviously when it is first put in it would only contain;
Modules (1)
so when they complete a module the I want to add the next module number.

What is the best way to get this inserted and also what is the best way to separate it when a query is made.
Any help would be appreciated.

2

Why not store these in a separate table related by a record(user?) id?
This way you store each module in a new row instead of comma separated value. It’s easier to manage and query later.

So something like

id | userid | module
1  |   1    |   1
2  |   1    |   2
3  |   1    |   3
4  |   2    |   1
5  |   2    |   2
6  |   3    |   1
1 Like