Hi,
I think that your problem has nothing to do with your apache version.
It has something to do with the mysql client library.
I had the same problem and this is how I solved it:
The mysql client library needs the uncompress function provided by libz. If you compile mysql all static the libz library doesn't get compiled in (a bug?).
Solutions:
(1) Recompile mysql and check that the Makefile of the mysql client contains "-lz" in the line containing the linker options
like -lmysqlclient. I didn't verify this yet because I chose to do it the second way in my case.
(2) recompile php4. After executing the configure script find all Makefiles that contain -lmysqlclient and ensure that those lines also contain -lz (add it manually if neccessary). Then do the make,
make install.
(If you compile php4 with the configure parameter --with-apache then one of the files in the directory <apache-src>/src/modules/php4 contains the linker options. Make sure that it contains the -lz argument, too.)
Important: If you do it the second way then all tools and software using the mysql client has to be checked for the -lz argument (especially the Msql-Mysql perl modules!).
I think that there are easier solutions but this one did it for me.
Greetings,
Thomas