How to separate columns list with mysql

Unknown_Designer · October 7, 2020, 5:01am

How to create saparate columns and create list with mysql

CJcorp · October 7, 2020, 8:05am

Use something like this.

This is an example go through it and create according to your need

Unknown_Designer · October 7, 2020, 8:27am

One More Thing @CJcorp how to remove columns name

CJcorp · October 7, 2020, 8:29am

This is also in the image start loop from 2

Unknown_Designer · October 7, 2020, 8:31am

Thanks

Rogerio_Rios · October 7, 2020, 11:00am

#off-topic
Understand that this format with | between columns.
This is not the original return from Mysql it is a formatted return created in procedure blocks “display table”.

pepocero · October 7, 2020, 4:39pm

With this method you can get the lists obtained from any query (also obtained from MySql) and put the data in a table. You can change the colours of the table using html.

I use this system.

I have a database in MySQL . I make a query and get a JSON. Then I convert that JSON to lists and put them in the table. And it looks very good.

system · November 6, 2020, 4:39pm

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.