--with-mysql=shared not working

Anon

i am using the debian packages of php on my box but have a problem with a specific app.

on running the app from the command line it gives me an error saying that it can't recognise the function mysql_connect(). i believe that one way of fixing this is to recompile php with mysql support directly compiled in.
this is not too much hassle but surely i should be able to tell php to load the mysql modules when it runs ????

i'm also confused that other apps that use mysql_connect() are working - altho these are coming through the apache php module and not the binary "/usr/bin/php".

thanks!

tom.

Anon

No. You have to compile php with the --with-mysql switch. The argument to that switch is the path to the mysql libraries. Why the apprehension to recompiling?

Anon

i'd rather not recompile as it is on a production server...

i have just solved the problem (based on what you wrote). i am using debian and i had the packages:

php4 - the standalone binary
php4-cgi - for apache
php4-mysql - mysql support

on adding the package "php4-cgi-mysql" it worked. which doesn't make any sense since php4-cgi was working fine and it was php4 that was having problems.

if you follow my logic it seems as tho the apache php should have been the one to fail and not the binary.

weird.