Bug #16923: mysql_fetch_object returning incomplete data

From: mark@artshouse.com Operating system: slackware 8.0 (modified) PHP version: 4.2.0 PHP Bug Type: MySQL related Bug description: mysql_fetch_object returning incomplete data This was found in an ongoing project I am upgrading from php 4.0.4pl1 code sample: $sql='select prodId, prodNum from products'; $result = mysql_query($sql); do { print_r($product); print $product->prodId ." ". $product-prodNum } while ($product = mysql_fetch_object($result)); print_r ($product) returns: stdClass Object ( [prodId] => [prodNum] => E-U-00-002) stdClass Object ( [prodId] => [prodNum] => E-U-00-003) stdClass Object ( [prodId] => [prodNum] => E-U-00-004) the real data would be prodId => 1, prodId => 2 the same thing done with mysql_fetch_array works perfectly (exact same sql, etc) I tried various loops (do..while, if, while) no changes. Tested this with php 4.1.2 and 4.2.0 w/ same errors. Works fine on 4.0.4pl1. php configure options as follows: './configure' \ '--with-mysql=/usr/local' \ '--enable-track-vars' \ '--with-dbase' \ '--with-gd=/usr/local/gd-1.8.4' \ '--with-ttf' \ '--with-t1lib' \ '--with-jpeg-dir' \ '--with-png-dir' \ '--with-tiff-dir' \ '--with-apxs=/usr/local/apache/bin/apxs' \ '--with-config-file-path=/usr/local/apache/conf' \ '--with-pdflib' \ '--enable-ftp' \ '--with-zlib-dir' I am unable to provide a backtrace (production server, sorry) -- Edit bug report at http://bugs.php.net/?id=16923&edit=1 -- Fixed in CVS: http://bugs.php.net/fix.php?id=16923&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=16923&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=16923&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=16923&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=16923&r=support Expected behavior: http://bugs.php.net/fix.php?id=16923&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=16923&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=16923&r=submittedtwice