Php can't run MySQL functions

[barran]

Hi there!

I'm fighting with this problem for a couple of days:

Call to undefined function:
mysql_connect() in /var/www/html/includes/database.mysql.inc

My system configuration is:

Linux Mandrake 9.0
Apache 1.3.26
PHP 4.2.3
MySQL 3.23.57

I've been told that the problem is that php was compiled with the mysql extensions. I've downloaded a package that was going to solve the problem. When I tried to install it I got all these dependences:

rpm -i hp-mysql-4.2.3-1mdk.x86_64.rpm
error: failed dependencies:
ld-linux-x86-64.so.2()(64bit) is needed by php-mysql-4.2.3-1mdk
libcrypt.so.1()(64bit) is needed by php-mysql-4.2.3-1mdk
libc.so.6()(64bit) is needed by php-mysql-4.2.3-1mdk
libm.so.6()(64bit) is needed by php-mysql-4.2.3-1mdk
libmysqlclient.so.10()(64bit) is needed by php-mysql-4.2.3-1mdk
libnsl.so.1()(64bit) is needed by php-mysql-4.2.3-1mdk
libpthread.so.0()(64bit) is needed by php-mysql-4.2.3-1mdk
libz.so.1()(64bit) is needed by php-mysql-4.2.3-1mdk
libc.so.6(GLIBC_2.2.5)(64bit) is needed by php-mysql-4.2.3-1mdk

Could anybody give me a hand? I think that this must be a quite common problem. Should I download another php version? Where could I get a right one?

Thanks a lot..

[stolzyboy]

go to the linux/unix help forum and there are some tuts at the top (sticky's) on how to compile php and install mysql etc...

http://www.phpbuilder.com/board/forumdisplay.php?s=&forumid=12

[KendersPlace]

I'm not sure if it is the same problem, and I am not familiar at all with Mandrake, only Red Hat, but I had a similar problem.

In order to get MySql to work from PHP I needed to add the RPM package "php-mysql".

Here is a link from rpmfind.net:

http://www.rpmfind.net/linux/rpm2html/search.php?query=php-mysql

I just installed the package with "RPM -iv php*" from the download directory and it installed imediately with no hassle, and I was then able to successfully use mySql functions from php.

Hope that helps.