1. Can I run PHP on IIS 4+?
Yes. Look at the PHP documentation.
1.a. If yes how do I install it?
Look at the PHP documentation. (not trying to be cute here; I haven't done a Windows install of PHP. It is apparently pretty straightforward, though.)
1.b. If no which one is the easiest to setup under Win 2000 or Linux?
I personaly plan to stay as far away from Win 2000 as possible. As far as Linux goes, Mandrake Linux 7.0 comes with the option to install Apache, PHP, and MySQL automatically.
If you want to install PHP the True Unix Way, though, you would download the source code from each website for Apache, PHP, and Mysql, and follow the documentation (included when you unpack source) for how to configure and compile these together.
2. Can I use an Access DB or SQL server?
Yes, go to www.phpbuilder.com,
where there is an article describing how to interface with MS Access. There is also plenty of information out there about connecting to MSSQL Server 7. (Essentially, connecting to any windows database uses the same method: ODBC, which PHP supports.)
2. If no, is MySQL worth of trying?
MySQL is my favorite Unix database app. It will run circles around just about any other database out there, mainly because it doesn't use transactions, like Oracle or MSSQL (there are pros and cons to this).
BUT, I understand that using the shareware MySQL for Windows is tricky. If you purchase the licensed version, (around $200) I believe you will get a newer version, and support, etc...
In general, I believe you will find PHP to be a great web scripting language to work with. (after learning PHP, ASP code actually looks pretty ugly). I personally much prefer Unix or Linux as a web server platform, though, (especialy FreeBSD) and if you are at a decision-making point, it'w worth taking a look.
[This message has been edited by rycamor (edited March 18, 2000).]