I have an external MySQL database that has forecasts from the year 2020 to 2028. I am trying to create a page that will dynamically load the data for the specific requested forecast. For example, going to page site.com/forecasts/forecast1 would load the chart for the first forecast and site/forecasts/forecast2 would take me to the same page but with the second forecast in the chart
I am currently using the plugin wpDataTables to load the data from the database but I am.unsure on how to create these multiple pages that use the same template
I am happy to do this without additional URLs as well if it’s easier to do it from something like a drop down list.
Hope this makes sense!
Thanks in advance!
[ad_2]