I guess we're missing some characters, because:
-c /root/build/php4/ext/mysql/l/php_mysql.lo

Doesn't add up.

IIC:
try this line:
/usr/local/gcc2/bin/gcc -E
-I/root/build/phIext/mysql/ -I/root/build/php4/ext/mysql/ -DPHP_ATOM_INC -I/root/build/php4/inclmain -I/root/build/php4 -I/root/build/php4/Zend -I/usr/local/ssl/include -I/usr/cal/include/libxml2
-I/usr/local/include/freetype2 -I/usr/local/gd/include
-I/us/usr/local/pgsql/include -I/root/build/php4/ext/xml/expat  -DLINUX=22
-DMOD_SSL=EAPI -I/root/build/php4/TSRM  -g -O2  -prefer-pic -c /root/build/php4/ext/mysql/libmysql/php_mysql.c -o php_mysql.out

Please adjust the missing characters.

then try:
grep -10 'For AIX string library' ./php_mysql.out

If that has any output, please paste it here.

[root@idave php4]# /usr/local/gcc2/bin/gcc -E -I/root/build/php4/ext/mysql/ -I/root/build/php4/ext/mysql/ -DPHP_ATOM_INC -I/root/build/php4/inclmain -I/root/build/php4 -I/root/build/php4/Zend -I/usr/local/ssl/include -I/usr/local/include/libxml2 -I/usr/local/include/freetype2 -I/usr/local/gd/include -I/usr/local/pgsql/include -I/root/build/php4/ext/xml/expat  -DLINUX=22 -DMOD_SSL=EAPI -I/root/build/php4/TSRM  -g -O2  -prefer-pic -c /root/build/php4/ext/mysql/php_mysql.c -o php_mysql.out
gcc: unrecognized option `-prefer-pic'
/root/build/php4/ext/mysql/php_mysql.c:32: php.h: No such file or directory
/root/build/php4/ext/mysql/php_mysql.c:33: php_globals.h: No such file or directory
[root@idave php4]#

[root@idave php4]# grep -10 'For AIX string library' ./php_mysql.out
grep: ./php_mysql.out: No such file or directory
[root@idave php4]#

Ok, there are obviously characters missing (-I/root/build/php4/inclmain).

The trick is, to get the line that fails, than strip -prefer-pic and add -E after gcc and change the output file to php_mysql.out by adding that to -o.
That calls the pre-processor on the file named after -c and resolves all pre-processor macro's and includes.

If you have an issue with your terminal, please use the 'script(1)' command, to capture all output from the make process to a file.

Since RedHat, comes with a stock gcc3 and you're trying to use gcc2, there's some conflict with headers going on, that creates buggy preprocessor macro's and/or defines.

That's why we're asking you to do this - it can be a local issue, or it can be a product of 'using gcc2 on RedHat 8'.

Sorry... I didn't understand what you are saying. I've tried with gcc3 - same error, so it can't be a product of 'using gcc2 on RedHat 8'.

Is PHP compatible with gcc3?

Please help me. I'm not a C programmer so I can't understand if the gcc command I've just typed in my terminal is right or wrong. It's not so obvious for me.

I've tried with the following command
[root@idave libmysql]# /usr/local/gcc2/bin/gcc -E -I/root/build/php4/ext/mysql/
-I/root/build/php4/ext/mysql/ -DPHP_ATOM_INC -I/root/build/php4/main -I/root/build/php4 -I/root/build/php4/Zend -I/usr/local/ssl/include -I/usr/local/include/libxml2 -I/usr/local/include/freetype2 -I/usr/local/gd/include -I/usr/local/pgsql/include -I/root/build/php4/ext/xml/expat  -DLINUX=22 -DMOD_SSL=EAPI -I/root/build/php4/TSRM -I/usr/local/mysql/include -g -O2  -prefer-pic -c /root/build/php4/ext/mysql/php_mysql.c -o php_mysql.out
gcc: unrecognized option `-prefer-pic'
/root/build/php4/ext/mysql/php_mysql.c:56: mysql.h: No such file or directory
[root@idave libmysql]#

Trying "pushd / && locate mysql.h %% popd" returns:
/root/build/courier-imap-1.6.0.20021025/authlib/authmysql.h
/root/build/courier-imap-1.6.0.20021025/authlib/README.authmysql.html
/root/build/vpopmail-5.2.1/vmysql.h
/root/build/php4/ext/dbx/dbx_mysql.h
/root/build/php4/ext/mysql/libmysql/mysql.h
/root/build/php4/ext/mysql/php_mysql.h
/root/build/mysql-4.0.4-beta/include/mysql.h
/root/build/mysql-4.0.4-beta/innobase/include/row0mysql.h
/root/build/php-4.3.0pre2/ext/dbx/dbx_mysql.h
/root/build/php-4.3.0pre2/ext/mysql/libmysql/mysql.h
/root/build/php-4.3.0pre2/ext/mysql/php_mysql.h
/root/build/php-4.2.3/ext/dbx/dbx_mysql.h
/root/build/php-4.2.3/ext/mysql/libmysql/mysql.h
/root/build/php-4.2.3/ext/mysql/php_mysql.h
/root/build/mysql-3.23.53/include/mysql.h
/root/build/mysql-3.23.53/innobase/include/row0mysql.h
/usr/share/apps/quanta/doc/php/ref.mysql.html
/usr/local/mysql/include/mysql/mysql.h

So I've tried:
[root@idave libmysql]# /usr/local/gcc2/bin/gcc -E -I/root/build/php4/ext/mysql/
-I/root/build/php4/ext/mysql/ -DPHP_ATOM_INC -I/root/build/php4/main -I/root/build/php4 -I/root/build/php4/Zend -I/usr/local/ssl/include -I/usr/local/include/libxml2 -I/usr/local/include/freetype2 -I/usr/local/gd/include -I/usr/local/pgsql/include -I/root/build/php4/ext/xml/expat  -DLINUX=22 -DMOD_SSL=EAPI -I/root/build/php4/TSRM -I/usr/local/mysql/include/mysql -g -O2  -prefer-pic -c /root/build/php4/ext/mysql/php_mysql.c -o php_mysql.out
gcc: unrecognized option `-prefer-pic'
[root@idave libmysql]#

and then the command "grep -10 'For AIX string library' ./php_mysql.out" hadn't any output.

No worries you're almost there :)

Just loose the '-prefer-pic'. Then please send php_mysql.out to my email.

Just sent.

any new? I'm still waiting...

Just sent to the new address you told me. Just to be sure, u can find the file at the following addresses:
ftp://ftp.idave.it/php_mysql.out
ftp://ftp.idave.it/php_mysql.out.tar.gz

Please try the following patch:
Index: global.h
===================================================================
RCS file: /repository/php4/ext/mysql/libmysql/global.h,v
retrieving revision 1.10
diff -u -r1.10 global.h
--- global.h    7 Jun 2002 15:07:53 -0000       1.10
+++ global.h    11 Nov 2002 21:15:37 -0000
@@ -133,9 +133,12 @@
 #if defined(_lint) && !defined(lint)
 #define lint
 #endif
+
+#ifdef SIZEOF_LONG_LONG
 #if SIZEOF_LONG_LONG > 4 && !defined(_LONG_LONG)
 #define _LONG_LONG 1           /* For AIX string library */
 #endif
+#endif
 
 #ifndef stdin
 #include <stdio.h>
@@ -502,8 +505,10 @@
 
 /* This is from the old m-machine.h file */
 
+#ifdef SIZEOF_LONG_LONG
 #if SIZEOF_LONG_LONG > 4
 #define HAVE_LONG_LONG 1
+#endif
 #endif
 
 #if defined(HAVE_LONG_LONG) && !defined(LONGLONG_MIN)


(basically, wrap the 2 occurrences of SIZEOF_LONG_LONG in global.h with #ifdef)

If that fixes it, please report the outcome of:
find /usr/include -type f -name "*.h" -print | xargs grep -l SIZEOF_LONG_LONG

By the way:
SIZEOF_LONG_LONG should also be set in main/php_config.h.

The grep for /usr/include, is to make sure it isn't canceled out somehow.

If it's not set in main/php_config.h, check config.log, to see why.

I'm sorry... How SIZEOF_LONG_LONG should be set in 
main/php_config.h???

Another question... How can I apply the patch? I'm sorry but I'm just a beginner C programmer...

grep SIZEOF_LONG_LONG /root/build/php4/main/php_config.h should give you output.

Let's first see that, then see if the patch is needed.

[root@idave main]# grep SIZEOF_LONG_LONG php_config.h
#define SIZEOF_LONG_LONG
[root@idave main]#

Well - that's the error. Now the why:
grep -A25 'checking size of long long' /root/build/php4/config.log

[root@idave main]# grep -A25 'checking size of long long' /root/build/php4/config.log
configure:45449: checking size of long long
configure:45613: /usr/local/gcc2/bin/gcc -o conftest -g -O2  -DLINUX=22 -DMOD_SSL=208112 -DUSE_HSREGEX -DEAPI  -Wl,-rpath,/usr/local/ssl/lib -L/usr/local/ssl/lib -Wl,-rpath,/usr/local/lib -L/usr/local/lib -Wl,-rpath,/usr/local/gd/lib -L/usr/local/gd/lib -Wl,-rpath,/usr/local/mcal/lib -L/usr/local/mcal/lib conftest.c -lmhash -lgmp -lgd -lfreetype -lpng -lz -ljpeg -lz -lgdbm -lcurl -lbz2 -lz -lcrypt -lssl -lcrypto -lresolv -lm -ldl -lnsl  -lcrypt -lcurl -lz -lssl -lcrypto -ldl
-lz -lxml2 -lz -lm >&5
/usr/local/lib/libgd.so: undefined reference to `XpmReadFileToXpmImage'
collect2: ld returned 1 exit status
configure:45616: $? = 1
configure: program exited with status 1
configure: failed program was:
#line 45597 "configure"
#include "confdefs.h"
#include <stdio.h>
#if HAVE_SYS_TYPES_H
# include <sys/types.h>
#endif
#if HAVE_SYS_STAT_H
# include <sys/stat.h>
#endif
#if STDC_HEADERS
# include <stdlib.h>
# include <stddef.h>
#else
# if HAVE_STDLIB_H
#  include <stdlib.h>
# endif
#endif
#if HAVE_STRING_H
# if !STDC_HEADERS && HAVE_MEMORY_H
[root@idave main]#

Try drop the gd stuff out of your configure line and try again. (use fresh sources!)

hmmm... I need GD ;-/

You can also try adding '--with-xpm-dir=/usr/X11' to your configure line. That mysql problem is caused by the fault
in GD stuff..

IT WORKED!!!! Yesssss ;-)))

Sorry, but your problem does not imply a bug in PHP itself.  For a
list of more appropriate places to ask for help using PHP, please
visit http://www.php.net/support.php as this bug system is not the
appropriate forum for asking support questions. 

Thank you for your interest in PHP.

user reports that the problem was fixed by specifying the correct location of the X11 librar(y|ies).

/bin/sh libtool --silent --mode=link /usr/local/gcc2/bin/gcc -export-dynamic -g
-O2  -export-symbols /root/build/php4/sapi/apache/php.sym -avoid-version -module -L/usr/local/ssl/lib -L/usr/local/lib -L/usr/X11R6/lib -L/usr/local/gd/lib -L/usr/local/mcal/lib -L/usr/local/pgsql/lib  -R /usr/local/ssl/lib -R /usr/local/lib -R /usr/X11R6/lib -R /usr/local/gd/lib -R /usr/local/mcal/lib -R /usr/local/pgsql/lib ext/zlib/zlib.lo ext/zlib/zlib_fopen_wrapper.lo ext/bcmath/bcmath.lo ext/bcmath/number.lo ext/bcmath/libbcmath/src/add.lo ext/bcmath/libbcmath/src/div.lo ext/bcmath/libbcmath/src/init.lo ext/bcmath/libbcmath/src/neg.lo ext/bcmath/libbcmath/src/outofmem.lo ext/bcmath/libbcmath/src/raisemod.lo ext/bcmath/libbcmath/src/rt.lo ext/bcmath/libbcmath/src/sub.lo ext/bcmath/libbcmath/src/compare.lo
ext/bcmath/libbcmath/src/divmod.lo ext/bcmath/libbcmath/src/int2num.lo ext/bcmath/libbcmath/src/num2long.lo ext/bcmath/libbcmath/src/output.lo ext/bcmath/libbcmath/src/recmul.lo ext/bcmath/libbcmath/src/sqrt.lo ext/bcmath/libbcmath/src/zero.lo ext/bcmath/libbcmath/src/debug.lo ext/bcmath/libbcmath/src/doaddsub.lo ext/bcmath/libbcmath/src/nearzero.lo ext/bcmath/libbcmath/src/num2str.lo ext/bcmath/libbcmath/src/raise.lo ext/bcmath/libbcmath/src/rmzero.lo ext/bcmath/libbcmath/src/str2num.lo ext/bz2/bz2.lo ext/calendar/calendar.lo ext/calendar/dow.lo ext/calendar/french.lo ext/calendar/gregor.lo ext/calendar/jewish.lo ext/calendar/julian.lo ext/calendar/easter.lo ext/calendar/cal_unix.lo ext/ctype/ctype.lo ext/curl/curl.lo ext/curl/curlstreams.lo ext/dba/dba.lo ext/dba/dba_cdb.lo ext/dba/dba_db2.lo ext/dba/dba_dbm.lo ext/dba/dba_gdbm.lo ext/dba/dba_ndbm.lo ext/dba/dba_db3.lo ext/dbx/dbx.lo ext/dbx/dbx_mysql.lo ext/dbx/dbx_odbc.lo ext/dbx/dbx_pgsql.lo ext/dbx/dbx_mssql.lo ext/dbx/dbx_fbsql.lo ext/dbx/dbx_oci8.lo ext/dbx/dbx_sybasect.lo ext/dio/dio.lo ext/domxml/php_domxml.lo ext/exif/exif.lo ext/ftp/php_ftp.lo ext/ftp/ftp.lo ext/gd/gd.lo ext/gd/gdttf.lo ext/gd/gdcache.lo ext/gmp/gmp.lo
ext/mbstring/mbfilter_ja.lo ext/mbstring/mbfilter_cn.lo ext/mbstring/mbfilter_tw.lo ext/mbstring/mbfilter_kr.lo ext/mbstring/mbfilter_ru.lo ext/mbstring/mbfilter.lo ext/mbstring/mbstring.lo ext/mbstring/mbregex.lo ext/mbstring/php_mbregex.lo ext/mbstring/html_entities.lo ext/mbstring/php_unicode.lo ext/mcal/php_mcal.lo ext/mhash/mhash.lo ext/mysql/php_mysql.lo ext/mysql/libmysql/libmysql.lo ext/mysql/libmysql/errmsg.lo ext/mysql/libmysql/net.lo ext/mysql/libmysql/violite.lo ext/mysql/libmysql/password.lo ext/mysql/libmysql/my_init.lo ext/mysql/libmysql/my_lib.lo ext/mysql/libmysql/my_static.lo ext/mysql/libmysql/my_malloc.lo ext/mysql/libmysql/my_realloc.lo ext/mysql/libmysql/my_create.lo ext/mysql/libmysql/my_delete.lo ext/mysql/libmysql/my_tempnam.lo ext/mysql/libmysql/my_open.lo ext/mysql/libmysql/mf_casecnv.lo ext/mysql/libmysql/my_read.lo ext/mysql/libmysql/my_write.lo ext/mysql/libmysql/errors.lo ext/mysql/libmysql/my_error.lo ext/mysql/libmysql/my_getwd.lo ext/mysql/libmysql/my_div.lo ext/mysql/libmysql/mf_pack.lo ext/mysql/libmysql/my_messnc.lo ext/mysql/libmysql/mf_dirname.lo ext/mysql/libmysql/mf_fn_ext.lo ext/mysql/libmysql/mf_wcomp.lo ext/mysql/libmysql/typelib.lo ext/mysql/libmysql/safemalloc.lo ext/mysql/libmysql/my_alloc.lo ext/mysql/libmysql/mf_format.lo ext/mysql/libmysql/mf_path.lo ext/mysql/libmysql/mf_unixpath.lo ext/mysql/libmysql/my_fopen.lo ext/mysql/libmysql/mf_loadpath.lo ext/mysql/libmysql/my_pthread.lo ext/mysql/libmysql/my_thr_init.lo ext/mysql/libmysql/thr_mutex.lo ext/mysql/libmysql/mulalloc.lo ext/mysql/libmysql/string.lo ext/mysql/libmysql/default.lo ext/mysql/libmysql/my_compress.lo ext/mysql/libmysql/array.lo ext/mysql/libmysql/my_once.lo ext/mysql/libmysql/list.lo ext/mysql/libmysql/my_net.lo ext/mysql/libmysql/dbug.lo ext/mysql/libmysql/strmov.lo ext/mysql/libmysql/strxmov.lo ext/mysql/libmysql/strnmov.lo ext/mysql/libmysql/strmake.lo ext/mysql/libmysql/strend.lo ext/mysql/libmysql/strfill.lo ext/mysql/libmysql/is_prefix.lo ext/mysql/libmysql/int2str.lo ext/mysql/libmysql/str2int.lo ext/mysql/libmysql/strinstr.lo ext/mysql/libmysql/strcont.lo ext/mysql/libmysql/strcend.lo ext/mysql/libmysql/bchange.lo ext/mysql/libmysql/bmove.lo ext/mysql/libmysql/bmove_upp.lo ext/mysql/libmysql/longlong2str.lo ext/mysql/libmysql/strtoull.lo ext/mysql/libmysql/strtoll.lo ext/mysql/libmysql/charset.lo ext/mysql/libmysql/ctype.lo ext/overload/overload.lo ext/pcre/pcrelib/maketables.lo ext/pcre/pcrelib/get.lo ext/pcre/pcrelib/study.lo ext/pcre/pcrelib/pcre.lo ext/pcre/php_pcre.lo ext/pgsql/pgsql.lo
ext/posix/posix.lo ext/session/session.lo ext/session/mod_files.lo ext/session/mod_mm.lo ext/session/mod_user.lo ext/shmop/shmop.lo ext/sockets/sockets.lo ext/standard/array.lo ext/standard/base64.lo ext/standard/basic_functions.lo ext/standard/browscap.lo ext/standard/crc32.lo ext/standard/crypt.lo ext/standard/cyr_convert.lo ext/standard/datetime.lo ext/standard/dir.lo ext/standard/dl.lo ext/standard/dns.lo ext/standard/exec.lo ext/standard/file.lo ext/standard/filestat.lo
ext/standard/flock_compat.lo ext/standard/formatted_print.lo ext/standard/fsock.lo ext/standard/head.lo ext/standard/html.lo ext/standard/image.lo ext/standard/info.lo ext/standard/iptc.lo ext/standard/lcg.lo ext/standard/link.lo ext/standard/mail.lo ext/standard/math.lo ext/standard/md5.lo ext/standard/metaphone.lo ext/standard/microtime.lo ext/standard/pack.lo ext/standard/pageinfo.lo ext/standard/parsedate.lo ext/standard/quot_print.lo ext/standard/rand.lo ext/standard/reg.lo ext/standard/soundex.lo ext/standard/string.lo ext/standard/scanf.lo ext/standard/syslog.lo ext/standard/type.lo ext/standard/uniqid.lo ext/standard/url.lo
ext/standard/url_scanner.lo ext/standard/var.lo ext/standard/versioning.lo ext/standard/assert.lo ext/standard/strnatcmp.lo ext/standard/levenshtein.lo ext/standard/incomplete_class.lo ext/standard/url_scanner_ex.lo ext/standard/ftp_fopen_wrapper.lo ext/standard/http_fopen_wrapper.lo ext/standard/php_fopen_wrapper.lo ext/standard/credits.lo ext/standard/css.lo ext/standard/var_unserializer.lo ext/standard/ftok.lo ext/standard/aggregation.lo ext/standard/sha1.lo ext/sysvsem/sysvsem.lo ext/sysvshm/sysvshm.lo ext/tokenizer/tokenizer.lo ext/wddx/wddx.lo ext/xml/xml.lo ext/xml/expat/xmlparse.lo ext/xml/expat/xmlrole.lo ext/xml/expat/xmltok.lo regex/regcomp.lo regex/regexec.lo regex/regerror.lo regex/regfree.lo TSRM/TSRM.lo TSRM/tsrm_strtok_r.lo TSRM/tsrm_virtual_cwd.lo main/main.lo main/snprintf.lo main/spprintf.lo main/php_sprintf.lo main/safe_mode.lo main/fopen_wrappers.lo main/alloca.lo main/php_ini.lo main/SAPI.lo main/rfc1867.lo main/php_content_types.lo main/strlcpy.lo main/strlcat.lo main/mergesort.lo main/reentrancy.lo main/php_variables.lo main/php_ticks.lo main/streams.lo main/network.lo main/php_open_temporary_file.lo main/php_logos.lo main/output.lo main/memory_streams.lo main/user_streams.lo Zend/zend_language_parser.lo Zend/zend_language_scanner.lo Zend/zend_ini_parser.lo Zend/zend_ini_scanner.lo Zend/zend_alloc.lo Zend/zend_compile.lo Zend/zend_constants.lo Zend/zend_dynamic_array.lo Zend/zend_execute_API.lo Zend/zend_highlight.lo Zend/zend_llist.lo Zend/zend_opcode.lo Zend/zend_operators.lo Zend/zend_ptr_stack.lo Zend/zend_stack.lo Zend/zend_variables.lo Zend/zend.lo Zend/zend_API.lo Zend/zend_extensions.lo Zend/zend_hash.lo Zend/zend_list.lo Zend/zend_indent.lo Zend/zend_builtin_functions.lo Zend/zend_sprintf.lo Zend/zend_ini.lo Zend/zend_qsort.lo Zend/zend_multibyte.lo Zend/zend_execute.lo sapi/cli/php_cli.lo sapi/cli/getopt.lo main/internal_functions_cli.lo -lmcal -lpq -lmhash -lgmp -lgd -lfreetype -lX11 -lXpm -lpng -lz -ljpeg -lz -lgdbm -lcurl -lbz2 -lz -lcrypt -lssl -lcrypto -lresolv -lm -ldl -lnsl -lcrypt -lcurl -lz -lssl -lcrypto -ldl -lz -lxml2 -lz -lm  -o sapi/cli/php
ext/mysql/libmysql/my_tempnam.lo: In function `my_tempnam':
/root/build/php4/ext/mysql/libmysql/my_tempnam.c:103: the use of `tempnam' is dangerous, better use `mkstemp'

Is this a problem?

no.