Holiday Notice – Support Unavailable on April 18 and April 21
We just wanted to let you know that our support team will be offline on Friday, April 18th (Good Friday) and Monday, April 21st (Easter Monday) due to the holidays.
We'll be back on Tuesday, ready to assist you!
In the meantime, if you need any help, feel free to:
-
Use the support widget in the bottom right corner on our websites (Amelia and wpDataTables) — our latest AI-powered assistant is there 24/7 to help with basic and intermediate questions,
-
Browse our detailed documentation (Amelia, wpDataTables)
-
Explore helpful articles,
-
Or check out our YouTube channels for video guides!
Amelia YouTube Channel
wpDataTables YouTube Channel
Thank you for your understanding, and we wish you a wonderful holiday weekend!
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.