Create table when column name is row in mysql

Hi @kikithecat,

Welcome to the forum! ??

You first need to write a pivot query that gives you the desired result. After that you can write a view for that query. Finally, you can use the view to show your data.

You can use a view to show your rows in a publication or a project just like a table. The plugin however, does not support updating view. If you want enable update functionality, you can add dynamic hyperlinks to your view. Dynamic hyperlinks are described here:
https://wpdataaccess.com/docs/documentation/data-explorer/table-settings/

Here is an example of a pivot query (see Raymond Nijland):
https://dba.stackexchange.com/questions/164711/how-to-pivot-rows-into-columns-mysql/164794

Does this help?

Best regards,
Peter

Dear Peter, thank you very much for this quick answer. Just to check if I understand well few more things.

1. Write a pivot query – Create query using, for example, PhpMyAdmin
2. View for that query – Create View it into PhpMyAdmin and than using that View as a source of data for WP Data Access
3. show your data – shortcode in post or page

Is this correct?

Hi @kikithecat,

Yes, that is correct! I’m leaving for a holiday, otherwise I would like to help you solve this issue. I’ll be back on August 17. Let me knowiyf you still nee help after my holiday…

Good luck! ??

Best regards,
Peter