So I have been out of web development for a few years but a friend asked me to help him with a project so I thought I would take a crack.
I need to create a database with information about jobs that he is doing for his customers. He wants it to be web based. I manage an application at work that uses an MS SQL 2000 database. I am familiar with writing queries and using the server management tools on a windows platform.
The host that I use offers MYSQL and MSSQL. If I am going to learn to manage a database, write web queries etc I am looking for advice on what I should invest my time learning. It seems to me that it would be best to learn PHP and write the site in that. Should I learn MS SQL or MYSQL? What the difference etc.
Whatever your recomendation, what tools do you use to manage the databases? is their a software like enterprise manager or query analyzer for MYSQL.
I have the advantage of having the server right here on our network at work. But for this I will be dealing with the host and only have access to their domain / account control panel.
what he needs is fairly simple so I will be hoping to look at some online tutorials to start.
thanks in advance.