Strange results from mysql_db_query

Hi, I got strange results if I use php-4.0RC1 with the bundled mysql client library on an redhat 5.2 system. Mysql_db_query allways returns false if I use an update,insert query. A select query works as expected. On a SuSE 6.2 system the updates are ok. Possible a glibc problem? It works all if I configure php to use the self compiled mysql libs on the redhat system. tom -------------------- system is: Base: Redhat 5.2 Intel Kernel: 2.2.14 Httpd: Apache/1.3.11 (Unix) mod_ssl/2.5.0 OpenSSL/0.9.4 PHP/4.0RC1 mod_fastcgi/2.2.3 -------------------- configure is: ./configure \ --with-apxs=%{apxs} \ --with-gd=/usr \ --with-config-file-path=${CONFDIR} \ --enable-track-vars \ --enable-memory-limit \ --enable-sysvsem \ --enable-sysvshm \ --disable-debug \ --enable-inline-optimization ---------------------- code is: <pre> <? $db = mysql_connect('reger','server','internet'); echo "db link: $db\n"; echo "\ndo insert ...\n"; $result = mysql_db_query('test','insert into test (id) values (42)',$db); echo "result: " . (($result) ? 'true' : 'false') . "\n"; echo "errno: " . mysql_errno($db) . "\n"; echo "affected_rows: " . mysql_affected_rows($db) . "\n"; echo "\ndo update ...\n"; $result = mysql_db_query('test','update test set id=42 where id=42',$db); echo "result: " . (($result) ? 'true' : 'false') . "\n"; echo "errno: " . mysql_errno($db) . "\n"; echo "affected_rows: " . mysql_affected_rows($db) . "\n"; echo "\ndo query ...\n"; $result = mysql_db_query('test','select * from test',$db); echo "result: " . (($result) ? 'true' : 'false') . "\n"; echo "errno: " . mysql_errno($db) . "\n"; echo "affected_rows: " . mysql_affected_rows($db) . "\n"; echo "result set: " . join(',',mysql_fetch_row($result)) . "\n"; ?> </pre> ---------------------- db is: # MySQL Server version 3.22.27 # # Table structure for table 'test' # CREATE TABLE test ( id int(11) ); --------------------- result page is: db link: Resource id #1 do insert ... result: false errno: 0 affected_rows: 0 do update ... result: false errno: 0 affected_rows: 0 ---------------------- error_log is: PHP Warning: MySQL: Unable to save result set in /home/BerlinOnline/Server/.bin/mysql-test.php on line 15 PHP Warning: MySQL: Unable to save result set in /home/BerlinOnline/Server/.bin/mysql-test.php on line 21 -- Tom Anheyer G+J BerlinOnline GmbH Tel. : +49-(0)30-2327-5210 im Pressehaus am Alexanderplatz Fax: +49-(0)30-2327-5596 Karl-Liebknecht-Straße 29 E-Mail: Tom.Anheyer@BerlinOnline.de D-10178 Berlin URL: http://www.BerlinOnline.de BerlinOnline ist ein Service von Berliner Zeitung, TIP BerlinMagazin, Berliner Kurier und Berliner Abendblatt.