Also, relational databases (against file databases) are more appropiate for concurrent access.
If you learn SQL syntax and you use it in MySQL it will be more useful for you in the future.
The UNIX / Microsoft server argument is a good one. In the end it will depend on what you already know now. I am assuming you have a Windows box and have installed PHP on it to dish up dynamic pages.
MySQL -vs- Access. They are both relational databases. As mentioned, Access will work great with ASP. Access is usually used as a front end to connect to an MS SQL Server, again with ASP pages. Access gives you the nice easy GUI that a brain-dead cat could use. MySQL is by far faster. SQL syntax is not tough. You can learn what you need to know in a couple of days of study. If you do not have to manage, install and config MySQL yourself (ie. somebody else is managing the server) MySQL is my personal pref. If you are not familiar with UNIX management you will spend more of your time beating your head against the wall than getting results. You can get PHP and MySQL on Windows.
ASP -vs- PHP is also another thing that will be based on your background. If you do not want to learn MySQL stay with ASP. If you want PHP, learn MySQL. If you do not want to learn ASP, stick to PHP and MySQL. If you already know ASP, PHP should be easy to learn (so long as you can script ASP in JScript).
You will find is hard to find resources on mixing technologies. Keep PHP and MySQL together and ASP and Access/SQLServer together.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.