Hello!

I am using IIS & mysql to for running a website in php.

My php page is working good but mysql connection failed, i.e couldn't retrive data from the database.

I have set C:\mysql\bin folder to the Path variable in Windows. the steps are as follows:

-> Right-click the My Computer icon on your desktop, then choose properties.
-> Click the Advanced tab, and then click Environment Variables.
-> In the list of System Variables, choose Path, and then click Edit.
-> At the end of the list of local folders, type ;C:\mysql\bin (the semi-colon is required!), and press ok.

Did configure IIS for php asfollows:

-> Click Start -> Settings -> Control Panel.
-> Double-click Administrative Tools.
-> Double-click Internet Services Manager.
-> On the Tree tab on the left, click the plus sign beside your computer's name, right-click the Default Web Site icon, then choose Properties.
-> Choose the Home Directory tab, then choose Configuration (near the bottom)
-> Click Add, then Browse.
-> Navigate to C:\PHP\php-cgi.exe, and select this.
-> Add in .php as the extension, and tick Check that file exists.


Did I miss something???
Can anyone tell me please???


Regards

Did the connection itself fail, or was it a database transaction that failed? What was the error message?

My script is ok. bcos i am running the same website in apache server and tis working well.

but when I tried to running it iis then its not retriving any data from the database.

I did setup php, mysql in different machine, not the same one.

please tell me whats wrong.

did i mistake to configue mysql or php or iis.

please tell me.

Is there an error message being generated? Is the connection being made at all, or is the problem with data retrieval?

There are several "packages" that auto configure Apache, PHP, and all the popular plugins and software. Would it be easier to use one of those, or is this going to be a production server?

http://www.apachefriends.org/en/xampp-windows.html