Using MySQL

Hi, guys.
I use php 5.2.3, IIS 5.1, Windows XP SP2 and MySQL 5.0.
So, this is my problem: I cannot use mysql functions though I properly set PATH env. variable, have libmysql.dll in my php directory and enabled mysql extension in php.ini. Documentation says I must compile php with support for MySQL, but how can I get to know is my php already compiled with such support and if not do I need to download some extra source files or libraries (except those, mentioned in documentation) to compile php with MySQL support? I got almost lost. Help me please.
Thanks in advance

I have a similar problem. I get an error message undefined function mysqli_connect(). I have read in a few places that I must re-compile with the mysql drivers, but I don't have a compiler, nor am I sure of what to compile. Also TIA>

For Windows operating systems, use the pre-compiled binary (download from php.net). Under Windows, unless you are adding your own custom extension that you wrote yourself, there is no need to be compiling PHP.

If you add the path to php (usually something like c:\php) to the Windows path statement, there is no need to copy any extension files around to get any extension to work.

Make sure that the php.ini extension_dir = setting points to where your extension .dll's are located. The name of the folder is different for php4 and php5.

Also, make sure that the extension .dll's are actually present. The .msi installer version of php does not include them.

Make sure that the php.ini that you are making changes to is the same one that php is using.

Under IIS, you must either make a registry entry to tell php where to look for the php.ini or you must copy it to the Windows folder. Under Apache, there is a httpd.conf setting that tells php where to look for the php.ini.

Under IIS, you must restart your computer to get changes made to php.ini to take effect. Under Apache, you only need to stop and start your web server.

If you make changes to the Windows path, you must restart your computer to get the change to take effect.

Most of the above information is contain in the install.txt file that comes with php (and is also repeated in the installation section of the PHP manual.)

If you are using IIS and there is no specific reason that you must use it, Apache is a much better choice.

Oh, Jesus Christ! Can you guess what was wrong?? The only thing I needed was to move my php.ini to the Windows directory. And official documentation tells NOTHING about it!!
Thanks man, you almost saved my life!!!))

In my case I had to add a c:\php\ext\ to my path even though the extension directory was set properly in the ini file. Thanks for all of the help. I do have one more problem that I will present as a new thread.