I am gettign the error   Unable to save result set when useing php to do querys to mysql.
here is an example
$link_id=mysql_connect("localhost","root");
mysql_select_db("vbulletin", $link_id);
$query_id = mysql_query('INSERT INTO style VALUES (1, 1, 1, \'Default\', 1)',$link_id);
if (!$query_id) {
        print mysql_error();
        print mysql_errno();
}

my configureation looks like
OPTIM="-O3" \
CFLAGS=" -fno-strict-aliasing" \
LIBS="-lpthread"
./configure \
--prefix=/opt/php-4.2.3 \
--with-apxs=/opt/bin/apxs \
--with-config-file-path=/opt/php-4.2.3/lib/ \
--without-pear \
--with-mysql=/opt/mysql \
--enable-oas \
--with-oci8 \
--with-gnu-ld \
--enable-inline-optimization \
--enable-track-vars \
--with-mcrypt \
--enable-sigchild

and I have also tryed builtin support and stand alone support ie
--with-mysql and --with-mysql=/opt/mysql

and have also tryed turning everything else off.
./configure \
--prefix=/opt/php-4.2.3 \
--with-apxs=/opt/bin/apxs \
--with-config-file-path=/opt/php-4.2.3/lib/ \
--without-pear \
--with-mysql=/opt/mysql
with the same results



I have atache my php.ini file to the end Please contact me if you need any more info. I was looking throught some other bug reports and it looks like it may have something to do with usein apxs but I need to compile it that way.

Byron
PHP Version 4.2.3

System Linux linsrv-2.iworld.com 2.4.16 #1 SMP Thu Dec 6 21:49:21 EST 2001 i686 unknown
Build Date Oct 21 2002 17:22:07
Configure Command './configure' '--prefix=/opt/php-4.2.3' '--with-apxs=/opt/bin/apxs' '--with-config-file-path=/opt/php-4.2.3/lib/' '--without-pear' '--with-mysql=/opt/mysql'
Server API Apache
Virtual Directory Support disabled
Configuration File (php.ini) Path /opt/php-4.2.3/lib/
Debug Build no
Thread Safety disabled

Zend logo This program makes use of the Zend Scripting Language Engine:
Zend Engine v1.2.0, Copyright (c) 1998-2002 Zend Technologies

PHP 4 Credits
Configuration
PHP Core
Directive Local Value Master Value
allow_call_time_pass_reference
On On
allow_url_fopen
1 1
always_populate_raw_post_data
0 0
arg_separator.input
& &
arg_separator.output
& &
asp_tags
Off Off
auto_append_file
no value no value
auto_prepend_file
no value no value
browscap
no value no value
default_charset
no value no value
default_mimetype
text/html text/html
define_syslog_variables
Off Off
disable_functions
no value no value
display_errors
On On
display_startup_errors
Off Off
doc_root
no value no value
enable_dl
On On
error_append_string
no value no value
error_log
no value no value
error_prepend_string
no value no value
error_reporting
no value no value
expose_php
On On
extension_dir
/opt/php-4.2.3/lib/php/extensions/no-debug-non-zts-20020429 /opt/php-4.2.3/lib/php/extensions/no-debug-non-zts-20020429
file_uploads
1 1
gpc_order
GPC GPC
highlight.bg
#FFFFFF #FFFFFF
highlight.comment
#FF8000 #FF8000
highlight.default
#0000BB #0000BB
highlight.html
#000000 #000000
highlight.keyword
#007700 #007700
highlight.string
#DD0000 #DD0000
html_errors
On On
ignore_user_abort
Off Off
implicit_flush
Off Off
include_path
.: .:
log_errors
Off Off
magic_quotes_gpc
On On
magic_quotes_runtime
Off Off
magic_quotes_sybase
Off Off
max_execution_time
30 30
open_basedir
no value no value
output_buffering
0 0
output_handler
no value no value
post_max_size
8M 8M
precision
14 14
register_argc_argv
On On
register_globals
Off Off
safe_mode
Off Off
safe_mode_exec_dir
1 1
safe_mode_gid
Off Off
safe_mode_include_dir
no value no value
sendmail_from
no value no value
sendmail_path
/usr/sbin/sendmail -t -i /usr/sbin/sendmail -t -i
short_open_tag
On On
SMTP
localhost localhost
sql.safe_mode
Off Off
track_errors
Off Off
unserialize_callback_func
no value no value
upload_max_filesize
2M 2M
upload_tmp_dir
no value no value
user_dir
no value no value
variables_order
no value no value
xmlrpc_error_number
0 0
xmlrpc_errors
Off Off
y2k_compliance
Off Off

xml
XML Support active
XML Namespace Support active
EXPAT Version 1.95.2

standard
Regex Library Bundled library enabled
Dynamic Library Support enabled
Path to sendmail /usr/sbin/sendmail -t -i

Directive Local Value Master Value
assert.active
1 1
assert.bail
0 0
assert.callback
no value no value
assert.quiet_eval
0 0
assert.warning
1 1
safe_mode_allowed_env_vars
PHP_ PHP_
safe_mode_protected_env_vars
LD_LIBRARY_PATH LD_LIBRARY_PATH
url_rewriter.tags
a=href,area=href,frame=src,form=fakeentry a=href,area=href,frame=src,form=fakeentry

session
Session Support enabled

Directive Local Value Master Value
session.auto_start
Off Off
session.cache_expire
180 180
session.cache_limiter
nocache nocache
session.cookie_domain
no value no value
session.cookie_lifetime
0 0
session.cookie_path
/ /
session.cookie_secure
Off Off
session.entropy_file
no value no value
session.entropy_length
0 0
session.gc_maxlifetime
1440 1440
session.gc_probability
1 1
session.name
PHPSESSID PHPSESSID
session.referer_check
no value no value
session.save_handler
files files
session.save_path
/tmp /tmp
session.serialize_handler
php php
session.use_cookies
On On
session.use_trans_sid
1 1

posix
Revision $Revision: 1.42.2.3 $

pcre
PCRE (Perl Compatible Regular Expressions) Support enabled
PCRE Library Version 3.4 22-Aug-2000

mysql
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 3.22.32
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /tmp/mysql.sock
MYSQL_INCLUDE -I/opt/mysql/include/mysql
MYSQL_LIBS -L/opt/mysql/lib/mysql -lmysqlclient

Directive Local Value Master Value
mysql.allow_persistent
On On
mysql.default_host
no value no value
mysql.default_password
no value no value
mysql.default_port
no value no value
mysql.default_socket
no value no value
mysql.default_user
no value no value
mysql.max_links
Unlimited Unlimited
mysql.max_persistent
Unlimited Unlimited

ctype
ctype functions enabled (experimental)

apache
APACHE_INCLUDE  
APACHE_TARGET  
Apache Version Apache/1.3.27
Apache Release 10327100
Apache API Version 19990320
Hostname:Port linuxnewbie.org:80
User/Group iworld(507)/507
Max Requests Per Child: 1000 - Keep Alive: on - Max Per Connection: 100
Timeouts Connection: 300 - Keep-Alive: 15
Server Root /www
Loaded Modules mod_setenvif, mod_ucache, mod_php4, mod_cgi, mod_include, mod_oas, mod_TargetD, mod_headers, mod_expires, mod_info, mod_status, mod_imap, mod_dir, mod_autoindex, mod_auth, mod_access, mod_rewrite, mod_alias, mod_actions, mod_so, mod_mime, mod_log_config, mod_env, http_core

Directive Local Value Master Value
child_terminate
0 0
engine
1 1
last_modified
0 0
xbithack
0 0

Apache Environment
Variable Value
DOCUMENT_ROOT /www/linewbie/linewbie
HTTP_ACCEPT text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,video/x-mng,image/png,image/jpeg,image/gif;q=0.2,text/css,*/*;q=0.1
HTTP_ACCEPT_CHARSET ISO-8859-1, utf-8;q=0.66, *;q=0.66
HTTP_ACCEPT_ENCODING gzip, deflate, compress;q=0.9
HTTP_ACCEPT_LANGUAGE en-us, en;q=0.50
HTTP_COOKIE bblastvisit=1034627028; bbuserid=1; bbpassword=6114ea2f09eb3dd3ab3b18aa9c51b1fc
HTTP_HOST 10.2.10.2
HTTP_USER_AGENT Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.1) Gecko/20020823 Netscape/7.0
ORACLE_HOME /d00/app/oracle/product/8.1.7
PATH /opt/sbin:/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin:/usr/bin/X11:/usr/X11R6/bin:/opt/bin:/opt/mysql/bin:/root/bin
REMOTE_ADDR 10.2.1.134
REMOTE_HOST icom6-fw.iword.com
REMOTE_PORT 46922
SCRIPT_FILENAME /www/linewbie/linewbie/php.php
SCRIPT_URI http://linuxnewbie.org/php.php
SCRIPT_URL /php.php
SERVER_ADDR 10.2.10.2
SERVER_ADMIN balbert@internet.com
SERVER_NAME linuxnewbie.org
SERVER_PORT 80
SERVER_SIGNATURE  
SERVER_SOFTWARE Apache
GATEWAY_INTERFACE CGI/1.1
SERVER_PROTOCOL HTTP/1.0
REQUEST_METHOD GET
QUERY_STRING  
REQUEST_URI /php.php
SCRIPT_NAME /php.php

HTTP Headers Information
HTTP Request Headers
HTTP Request GET /php.php HTTP/1.0
Accept text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,video/x-mng,image/png,image/jpeg,image/gif;q=0.2,text/css,*/*;q=0.1
Accept-Charset ISO-8859-1, utf-8;q=0.66, *;q=0.66
Accept-Encoding gzip, deflate, compress;q=0.9
Accept-Language en-us, en;q=0.50
Cookie bblastvisit=1034627028; bbuserid=1; bbpassword=6114ea2f09eb3dd3ab3b18aa9c51b1fc
Host 10.2.10.2
User-Agent Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.1) Gecko/20020823 Netscape/7.0
HTTP Response Headers
X-Powered-By PHP/4.2.3
Connection close
Content-Type text/html

Additional Modules

Environment
Variable Value
PWD /opt/php-4.2.3/lib
HOSTNAME linsrv-2.iworld.com
LESSOPEN |/usr/bin/lesspipe.sh %s
USER root
LS_COLORS no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=01;32:*.cmd=01;32:*.exe=01;32:*.com=01;32:*.btm=01;32:*.bat=01;32:*.sh=01;32:*.csh=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.gz=01;31:*.bz2=01;31:*.bz=01;31:*.tz=01;31:*.rpm=01;31:*.cpio=01;31:*.jpg=01;35:*.gif=01;35:*.bmp=01;35:*.xbm=01;35:*.xpm=01;35:*.png=01;35:*.tif=01;35:
MACHTYPE i386-redhat-linux-gnu
OLDPWD /usr/src/build/php-4.2.3
MAIL /var/spool/mail/root
INPUTRC /etc/inputrc
BASH_ENV /root/.bashrc
LANG en_US
ORACLE_HOME /d00/app/oracle/product/8.1.7
DISPLAY linsrv-2.iworld.com:10.0
LOGNAME root
SHLVL 1
SHELL /bin/bash
USERNAME root
HOSTTYPE i386
OSTYPE linux-gnu
HISTSIZE 1000
TERM xterm
HOME /root
PATH /opt/sbin:/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin:/usr/bin/X11:/usr/X11R6/bin:/opt/bin:/opt/mysql/bin:/root/bin
_ /opt/bin/httpd

PHP Variables
Variable Value
_COOKIE["bblastvisit"] 1034627028 
_COOKIE["bbuserid"] 1 
_COOKIE["bbpassword"] 6114ea2f09eb3dd3ab3b18aa9c51b1fc 
_SERVER["DOCUMENT_ROOT"] /www/linewbie/linewbie 
_SERVER["HTTP_ACCEPT"] text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,video/x-mng,image/png,image/jpeg,image/gif;q=0.2,text/css,*/*;q=0.1 
_SERVER["HTTP_ACCEPT_CHARSET"] ISO-8859-1, utf-8;q=0.66, *;q=0.66 
_SERVER["HTTP_ACCEPT_ENCODING"] gzip, deflate, compress;q=0.9 
_SERVER["HTTP_ACCEPT_LANGUAGE"] en-us, en;q=0.50 
_SERVER["HTTP_COOKIE"] bblastvisit=1034627028; bbuserid=1; bbpassword=6114ea2f09eb3dd3ab3b18aa9c51b1fc 
_SERVER["HTTP_HOST"] 10.2.10.2 
_SERVER["HTTP_USER_AGENT"] Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.1) Gecko/20020823 Netscape/7.0 
_SERVER["ORACLE_HOME"] /d00/app/oracle/product/8.1.7 
_SERVER["PATH"] /opt/sbin:/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin:/usr/bin/X11:/usr/X11R6/bin:/opt/bin:/opt/mysql/bin:/root/bin 
_SERVER["REMOTE_ADDR"] 10.2.1.134 
_SERVER["REMOTE_HOST"] icom6-fw.iword.com 
_SERVER["REMOTE_PORT"] 46922 
_SERVER["SCRIPT_FILENAME"] /www/linewbie/linewbie/php.php 
_SERVER["SCRIPT_URI"] http://linuxnewbie.org/php.php 
_SERVER["SCRIPT_URL"] /php.php 
_SERVER["SERVER_ADDR"] 10.2.10.2 
_SERVER["SERVER_ADMIN"] balbert@internet.com 
_SERVER["SERVER_NAME"] linuxnewbie.org 
_SERVER["SERVER_PORT"] 80 
_SERVER["SERVER_SIGNATURE"]  
_SERVER["SERVER_SOFTWARE"] Apache 
_SERVER["GATEWAY_INTERFACE"] CGI/1.1 
_SERVER["SERVER_PROTOCOL"] HTTP/1.0 
_SERVER["REQUEST_METHOD"] GET 
_SERVER["QUERY_STRING"]  
_SERVER["REQUEST_URI"] /php.php 
_SERVER["SCRIPT_NAME"] /php.php 
_SERVER["PATH_TRANSLATED"] /www/linewbie/linewbie/php.php 
_SERVER["PHP_SELF"] /php.php 
_SERVER["argv"]

Array
(
)

 
_SERVER["argc"] 0 
_ENV["PWD"] /opt/php-4.2.3/lib 
_ENV["HOSTNAME"] linsrv-2.iworld.com 
_ENV["LESSOPEN"] |/usr/bin/lesspipe.sh %s 
_ENV["USER"] root 
_ENV["LS_COLORS"] no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=01;32:*.cmd=01;32:*.exe=01;32:*.com=01;32:*.btm=01;32:*.bat=01;32:*.sh=01;32:*.csh=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.gz=01;31:*.bz2=01;31:*.bz=01;31:*.tz=01;31:*.rpm=01;31:*.cpio=01;31:*.jpg=01;35:*.gif=01;35:*.bmp=01;35:*.xbm=01;35:*.xpm=01;35:*.png=01;35:*.tif=01;35: 
_ENV["MACHTYPE"] i386-redhat-linux-gnu 
_ENV["OLDPWD"] /usr/src/build/php-4.2.3 
_ENV["MAIL"] /var/spool/mail/root 
_ENV["INPUTRC"] /etc/inputrc 
_ENV["BASH_ENV"] /root/.bashrc 
_ENV["LANG"] en_US 
_ENV["ORACLE_HOME"] /d00/app/oracle/product/8.1.7 
_ENV["DISPLAY"] linsrv-2.iworld.com:10.0 
_ENV["LOGNAME"] root 
_ENV["SHLVL"] 1 
_ENV["SHELL"] /bin/bash 
_ENV["USERNAME"] root 
_ENV["HOSTTYPE"] i386 
_ENV["OSTYPE"] linux-gnu 
_ENV["HISTSIZE"] 1000 
_ENV["TERM"] xterm 
_ENV["HOME"] /root 
_ENV["PATH"] /opt/sbin:/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin:/usr/bin/X11:/usr/X11R6/bin:/opt/bin:/opt/mysql/bin:/root/bin 
_ENV["_"] /opt/bin/httpd