Help Bigred Nerd Out

[NightGizmo]

MySQL is a great database but you'll need to know SQL in order to use it (it's not too difficult to learn the basics, assuming you have some kind of tech background already). But if you want powerful reporting over a large set of data, it's going to be much better than Excel. I haven't used Access much but if you're going to build a web interface to do your reporting, you are much better off sticking with MySQL. PHP makes getting to your data really easy in a MySQL DB (assuming you know SQL).

MySQL has a good GUI you can install on your local machine, too, which is free. That will let you setup your tables and view the raw data directly for development and debugging.

[bigred]

MySQL is a great database but you'll need to know SQL in order to use it (it's not too difficult to learn the basics, assuming you have some kind of tech background already). But if you want powerful reporting over a large set of data, it's going to be much better than Excel. I haven't used Access much but if you're going to build a web interface to do your reporting, you are much better off sticking with MySQL. PHP makes getting to your data really easy in a MySQL DB (assuming you know SQL).

MySQL has a good GUI you can install on your local machine, too, which is free. That will let you setup your tables and view the raw data directly for development and debugging.

So just to clarify, I'll be using php to submit sql queries/writes to the mysql db? I'm aware of sql and have used a sql assistant to view views/data before but any good tutorial sites would be appreciated.