ID: 29002 Updated by: [EMAIL PROTECTED] Reported By: mark at nostromo dot net -Status: Open +Status: Assigned Bug Type: MySQL related Operating System: suse 9.1 AMD64 PHP Version: 5.0.0RC3 -Assigned To: +Assigned To: georg New Comment:
Previous Comments: ------------------------------------------------------------------------ [2004-07-03 20:57:53] mark at nostromo dot net Description: ------------ I've duplicated this problem on 2 separate 64-bit opteron boxes. Both are running Suse 9.1 64-bit. I'm using apache 1.3.31, Mysql 4.1.3-beta, and PHP 5.0 RC3. This may be a 64-bit related issue because the same query returns the correct results when PHP is compiled and run on 32-bit linux. Also, if I use the normal mysql function calls, it returns the correct results on the opteron. So it may be an issue with mysqli and 64-bit. But that's only a guess. Reproduce code: --------------- $sql = "select config_id, config_name from config_name"; if ($stmt = $mysql->prepare($sql)) { $stmt->execute(); $stmt->bind_result($id, $name); while ($stmt->fetch()) { echo "<tr> <td>$id</td> <td>$name</td> </tr>\n"; } $stmt->close(); } Expected result: ---------------- 1 suse-default 2 laptop-default Actual result: -------------- 32778017877000193 suse-default 32778017877000194 laptop-default ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=29002&edit=1