hi

i tried to install php using following command :
--------------------------------------------------------------------------------------

'./configure' '--enable-versioning' '--enable-memory-limit' '--with-layout=GNU' '--with-config-file-scan-dir=/usr/local/etc/php' '--with-mysql=/usr/local' '--disable-all' '--with-regex=php' '--disable-cli' '--with-apxs2=/usr/local/sbin/apxs' '--prefix=/usr/local' 'i386-portbld-freebsd5.4'

--------------------------------------------------------------------------------------

after running "Make" and "make install" when i tried to restart apache, it gave me the following error:

--------------------------------------------------------------------------------------

Syntax error on line 274 of /usr/local/etc/apache2/httpd.conf:
Cannot load /usr/local/libexec/apache2/libphp4.so into server: /usr/local/libexec/apache2/libphp4.so: Undefined symbol "mysql_drop_db"
--------------------------------------------------------------------------------------

Line number 274 in httpd.conf is :

LoadModule php4_module libexec/apache2/libphp4.so

--------------------------------------------------------------------------------------

In the above configure command if i remove the path to mysql i.e.

'--with-mysql' instead of '--with-mysql=/usr/local'

then apache does not give any error. But i don't want it to do that way.

Please help.

Are you sure the /usr/local is you mysql install directory. It should be something like /usr/local/mysql

i re-installed mysql at /usr/local/mysql.
but the same problem persisted.(when i installed using -with--mysql=/usr/local/mysql)
Then i installed php without giving the path to mysql i.e. only '-with--mysql'.
And then installed the package "php4-mysql".
Now it is working fine.

Any thoughts on what was the previous problem ?

When you compile php with the "--with-mysql" you use the built-in mysql support of php. When you add the path to your mysql installation then php uses the header files of your version of mysql to compile the mysql support. I don't know how you installed mysql, or what php4-mysql package is, but I suspect that you missed those header files, or they were the wrong version and that package fixed it.