On Fri, May 27, 2016 at 3:30 PM, Mike Copeland mike@ggisoft.com wrote:
John,
A few thoughts... What software you use will depend on where you host the data. Preferably it is hosted on a Linux box (because anything Microsoft is evil, lol) and you're correct that MySQL will be the target storage engine.
John-
Like Mike said you have some options... MySQL (or PostGReSQL) would be my choice for the data - I'm sure there are others.
Do you know any ASP? I ask because at least for me the hard part about getting started writing backend database and reporting tools was realizing that as you load a page you can be going back and forth between static code (HTML) and dynamic code (the ASP or PHP). Once you get a handle on that your progress goes faster and faster...
The concept is pretty simple - more or less pull the data using whatever criteria or options you or the user select, use HTML to build a table (as in HTML, not database), ratchet through the records and create the HTML tags for each line as you go.... You'll be doing a lot of "<TR><TD> </TR></TD> " matching... ;)
It's been a while for me personally but a lot of the folks around here I'm sure are up to speed with this and happy to help...
Good luck!