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?)
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.
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.
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.