Unfortunately something like that is not possible with built-in functionalities but if you are creating a table from MySQL you can transpose a table directly in query.
thank you for your patience and your good informations. A last question: What is the different between MySQL table and wpDataTable? I use the Mysql tabels now without any problems in WP. In my database I use the wp_tables and my mysql_tables together.
wpDataTable is table that is created with our plugin. And MySQL is on of many sources from that you can create wpDataTable. Other sources from that you can create wpDataTable are: Excel file, CSV file, Google Spreadsheet...
thank you for the informations. Is it right, I understand that wpDataTable is a proprietary standard from your company to generate the tables ? You did`nt answer my question: What is the different between MySQL table and
wpDataTable? I use 15 MySQL tables in the database. So I have all the tables to transfer to wpDataTable ? What does it mean for other PHP programms ?
Then I didn't understand your question. How do you mean what is the difference between wpDataTables and MySQL tables? wpDataTables are tables created with wpDataTables plugin and MySQL tables are tables in your database and you can create wpDataTable from MySQL tables. You can create how many you want wpDataTables from MySQL tables.
You can take a look here how you can create wpDataTables from MySQL query:
now I generate the table directly from the MySQL-tables and it works good. What is the sense to transfer the MySQL-tables to wpDataTables ? Is it the only way to change collumns to rows ?
"What is the sense to transfer the MySQL-tables to wpDataTables ?" - If you want to create table in WordPress from MySQL query you can do it with our plugin. Many users use this to create wpDataTable that will show on their website that gets data from their databases.
"Is it the only way to change columns to rows ?" - Yes the only way to transpose the table is to write MySQL query that will do that.
is it possible
to change (transpose) rows to collumns ?
Hi Heribert,
Thank you for your purchase.
Unfortunately something like that is not possible with built-in functionalities but if you are creating a table from MySQL you can transpose a table directly in query.
Hi Milos,
Thank you. Con I do this with
wpDataTables ?
Best Regards, Heribert
Hi Heribert,
Yes if you are using MySQL tables you can transpose directly in query but otherwise no. You have to write query that will transpose rows and columns.
Hi Milos, do you mean the tutorial creating mysql-based wp DataTable:
In this tutorial we will show how to create a wpDataTable based on a query to MySQL table.................I have an existing mysql DB with a lot of informations. Can I do it with this ?
Best Regards, Heribert
Hi Heribert,
Yes you can transpose MySQL table and create wpDataTable. Please take a look at something like this how to transpose MySQL table - http://stackoverflow.com/questions/3392956/sql-how-to-transpose
You just need to write query that will change columns and rows and to create wpDataTable from that query. You can take a look here how to create MySQL based wpDataTable - http://wpdatatables.com/video-course/creating-wpdatatables-from-existing-data-sources/creating-mysql-based-wpdatatables-with-server-side-processing-video/
Hi Milos,
thank you for your patience and your good informations. A last question: What is the different between MySQL table and wpDataTable? I use the Mysql tabels now without any problems in WP. In my database I use the wp_tables and my mysql_tables together.
Best Regards, Heribert
Hi Heribert,
wpDataTable is table that is created with our plugin. And MySQL is on of many sources from that you can create wpDataTable. Other sources from that you can create wpDataTable are: Excel file, CSV file, Google Spreadsheet...
You can take a look at our documentation how to create wpDataTable in various ways - http://wpdatatables.com/documentation/creating-wpdatatables/
Hi Milos,
thank you for the informations. Is it right, I understand that wpDataTable is a proprietary standard from your company to generate the tables ? You did`nt answer my question: What is the different between MySQL table and wpDataTable? I use 15 MySQL tables in the database. So I have all the tables to transfer to wpDataTable ? What does it mean for other PHP programms ?
Best Regards, Heribert
Hi Heribert,
Then I didn't understand your question. How do you mean what is the difference between wpDataTables and MySQL tables? wpDataTables are tables created with wpDataTables plugin and MySQL tables are tables in your database and you can create wpDataTable from MySQL tables. You can create how many you want wpDataTables from MySQL tables.
You can take a look here how you can create wpDataTables from MySQL query:
http://wpdatatables.com/documentation/creating-wpdatatables/creating-mysql-based-wpdatatables/
http://wpdatatables.com/documentation/creating-wpdatatables/creating-mysql-based-wpdatatables-with-server-side-processing/
Hi Milos,
now I generate the table directly from the MySQL-tables and it works good. What is the sense to transfer the MySQL-tables to wpDataTables ? Is it the only way to change collumns to rows ?
Best Regards, Heribert
Hi Heribert,
"What is the sense to transfer the MySQL-tables to wpDataTables ?"
- If you want to create table in WordPress from MySQL query you can do it with our plugin. Many users use this to create wpDataTable that will show on their website that gets data from their databases.
"Is it the only way to change columns to rows ?"
- Yes the only way to transpose the table is to write MySQL query that will do that.