Discussion on:

How do I? Install, configure and integrate PHP and MySQL on Windows?

Is there a better combination for Web sites than PHP and MySQL? What is it? Would you like to write a How do I? article explaining how to set it up?

This article specifically applies if your Dreamweaver cannot see the tables in your MySQL database or you are getting the error "Client does not support authentication protocol requested by server; consider upgrading MySQL client" when you look at a php page in a web browser served from a Windows 2000, XP or 2003 Server.

Full Fix: http://www.synergymx.com/stuff_detail.asp?ID=102

Good guide, however I opted to use the .msi installer that PHP now comes with, which caused a small problem.

Environment: PHP 5.2.4, IIS 6.0 ISAPI, Windows Server 2003.

Installation: Simply downloaded the PHP 5.2.4 installer [22,002Kb] - 30 August 2007 and ran it doing next, next until Finish.

To get rid of 405 error, ensure that your php directory allows scripts. Start->Control Panel->Administrative Tools->Internet Information Services-> (select website, navigate to directory with your php and right-click your directory) -> Properties -> Directory TAB -> Change Execute Permissions from "None" to "Scripts" (to allow PHP).

To get rid of 404 error, ensure that your executable mapping for the .php extension is properly coded. Start->Control Panel->Administrative Tools->Internet Information Services-> (select web site) ->Properties->Home Directory->Configuration->Mapping and then change the Executable Path for .php files from C:\Program~\PHP\php5is~1.DLL (or whatever crazy path) to "C:\Program Files\PHP\php5isapi.dll"

Everything except the test works...

This the error I receive:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\Inetpub\wwwroot\dntest.php on line 10

Any help on this would be appreciated greatly!