When i'm trying to send query from PHP 5.4.6 TS,VC9 to MySQL 5.5 (NTS,VC9) I get the message:
Fatal error: Call to undefined function mysql_connect()
after restarting Apache 2.2 on (Windows xp) it says:
PHP Startup: mysql: Unable to initialize module
Module compiled with build ID=API20100525,NTS,VC9
PHP compiled with build ID=API20100525,TS,VC9
These options needs to match
How can I solve this issue?
You probably installed PHP 5.4 without the package for mysql support. In some distributions of Linux, the PHP mysql extension is in a separate package.
For example, on my CentOS VM I have these packages installed:
$ rpm -qa | grep php
php55w-common-5.5.0-1.w6.x86_64
php55w-pear-1.9.4-6.w6.noarch
php55w-cli-5.5.0-1.w6.x86_64
php55w-mysql55-5.5.0-1.w6.x86_64
php55w-5.5.0-1.w6.x86_64
php55w-pdo-5.5.0-1.w6.x86_64
As for how to resolve this error, it depends on what distro of Linux you're using, and what's the package repo from which you're installing PHP.
PS: You shouldn't be using the deprecated mysql_* extension at all, unless you need to support legacy PHP code. Use mysqli or PDO.