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!
I'm using wpDataTables to display the scores for the upcoming college wrestling season
(seen here: http://www.mattalkonline.com/2016-17-college-dual-meet-scores/)
What I want to do with this data is to create standings (or sports tables) that display the total wins and losses of each team. I did this last year on my site using an embed of a google spreadsheet, but I believe a database would be more flexible.
Are there queries out there that will total the wins and losses by team (or total up each name in each field and total it and display like a win-loss record?)
Here is last year's embed. http://www.mattalkonline.com/college-wrestling-standings-15-16/
My sheet last year was in Google Sheets, so I ran formulas to tabulate them. Is anyone here familiar on how to do that or if wpDataTables can handle it?
If wpDataTables can't handle it, I might just be better off doing it the old way. I love this plugin, and I'm a novice with MySQL though, so the learning curve has been tough. Appreciate any input.
Hi Jason,
Our plugin are capable of showing most of the results that you can get in database management software like phpMyAdmin or Workbench.
MySQL is supporting some of mathematical operations as well as aggregate functions but please keep in mind that if you are using functions in your queries we are strongly suggesting you to use MySQL VIEW.
You should be able to find appropriate queries or at least parts of it on web and if can't manage it yourself we can offer you to hire one of our developers to help you with it as paid customization service.