Question about mysql vs. sql server 2005 express for websites

[malikk]

Hello,
Sorry about the long post. I am doing my senior project and I have made a database in SQL Server 2005 expres on my windows 7 machine. I am going to make a website that utilizes this database but I am unsure how to use PHP to connect to the sql server 2005 express and how difficult it will be. Is anyone able to help me? Or should i switch over to mysql (I have done it in mysql so I thought I would use sql server 2005 to be introduced to it as well). I also eventually (as i am doing everything on my personal computer which has mac os x AND windows 7 (which is where i am doing everything at the moment)) will need to move the database to another machine and the website, for when I need to present everything I have done.

Do you guys have any suggestions on how I should choose between mysql and sql server 2005?

[ryanbutler]

You can use SQL Server with PHP but I don't know what the driver is. I've always suck with MySQL/PHP or SQL Server/.NET, that way I don't have this problem.

You might check google for .net drivers for my sql.

[ssystems]

Check This (http://www.microsoft.com/sqlserver/2005/en/us/PHP-Driver.aspx)

Keep in mind if you don't have access to the server to install the drivers (when you move it to another machine), it is better to utilize your providers' dbs.