Fatal error: Call to undefined function mysql_connect()

[lychee1981]

Hi, I'm a newbie, I followed the instruction from kevin's book (build your own database driven website 3rd edition) and installed PHP5.2.8, edited php.ini with extension_dir="c:\php\ext", uncommented extension=php_mysql.dll in php.ini under c:/windows

I installed mysql 5.0.67 using installer, played with the database using command prompt and everything seems working.

I am using IIS5.1, played with today.php to display today's date using php and everything seems fine.

The problem occurred when i use $dbcnx = mysql_connect('localhost', 'root', 'password'); the error displayed is Fatal error: Call to undefined function mysql_connect().

I ran phpinfo() and the extension_dir is correctly displayed as c:\php\ext, i check in the ext folder and php_mysql.dll do exist there. I can't seem to think of any reason that why php_mysql.dll cannot be loaded. when i tried php4 about four years ago i don't think i have this problem. Tried to check on the web and couldn't find any answer, wish someone here could help... Thx in advance.

[krzyk]

Maybe the PHP that you downloaded doesn't come with mysql driver?
Search for the file from you php.ini: php_mysql.dll, maybe it is missing.

[Wardrop]

Check your php log and windows event viewer.

[lychee1981]

nothing in the windows event viewer, i think...

These errors are few hours before, not sure it's related or not..
C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.67-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)

TCP/IP has reached the security limit imposed on the number of concurrent TCP connect attempts.

i turned off skype so i dun think skype is an issue anymore.

Where is the php log actually?

[bingu]

Try xampp for windows.
XAMPP is an easy to install Apache distribution containing MySQL, PHP and Perl.

I can't post link, just google it.

[crmalibu]

You generally need to restart the webserver after making a change to php.ini(reboot)

Also, make sure you're modifying the correct php.ini. do a phpinfo() to find the path to one php is actually using.

[lychee1981]

Hi, i finally decided to uninstall and install with the installer version and it seems to work now, i really dun understand computers sometimes, thx everyone for your precious time and advice!