php and MySQL and Apache

[Anon]

Apache, MySQL, and PHP 4.0 all are installed and appear to be working properly. A PHP file renders properly in my web browser.

Next, I tried to connect via PHP script to a MySQL database table that I had set up manually.

In this script I am issuing a simple mysq_connect() statement, but I get a Fatal Error: Call to undefined function: mysql_connect in /var/www/html/guest.php

Is there another piece of software I need?
Or do I need to change a configuration file?

Thank you.

Linda

[Anon]

I'm no expert, but generally you get undefined functions when the functions haven't been compiled in... so you need to recompile php --with-mysql for it to be able to connect.

[Anon]

I thought PHP had MySql supprot built in. Double check the spelling of the function. Do you have "mysq_connect" instead of "mysql_connect"?

Hank

[Anon]

I uninstalled that version of php and installed a newer version of php from the Redhat site.

Now the error message is --->
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in /var/www/html/guest.php

I think the underlying problem is the php doesn't seem to be configured for MySQL.

My phpinfo shows the configuration is '--without-mysql'

How do I change it to '--with-mysql'????