PHP 4.0 Bug #10138 Updated: mysql_insert_id() returns incorrect value

ID: 10138 User Update by: jules@acris.co.uk Old-Status: Open Status: Closed Bug Type: MySQL related Description: mysql_insert_id() returns incorrect value OK; I just tested with the mysql C interface and that didn't work right either, so I guess I'll take this over to mysql. Sorry to bother you fine folks! Previous Comments: --------------------------------------------------------------------------- [2001-04-03 13:12:24] jules@acris.co.uk Information from the RPMs of the MySQL packages: [root@fddth03-157-31 /root]# rpm -q -i -f /usr/lib/libmysqlclient.so.10.0.0 Name : MySQL-shared Relocations: (not relocateable) Version : 3.23.33 Vendor: (none) Release : 1 Build Date: Fri Feb 9 02:42:35 2001 Install date: Thu Mar 8 20:05:07 2001 Build Host: mysql-work Group : Applications/Databases Source RPM: MySQL-3.23.33-1.src.rpm Size : 437510 License: GPL / LGPL Packager : David Axmark <david@mysql.com> URL : http://www.mysql.com/ Summary : MySQL - Shared libraries [root@fddth03-157-31 /root]# rpm -q -i -f /usr/bin/mysql Name : MySQL-client Relocations: (not relocateable) Version : 3.23.33 Vendor: (none) Release : 1 Build Date: Fri Feb 9 02:42:35 2001 Install date: Thu Mar 8 20:06:03 2001 Build Host: mysql-work Group : Applications/Databases Source RPM: MySQL-3.23.33-1.src.rpm Size : 2697037 License: GPL / LGPL Packager : David Axmark <david@mysql.com> URL : http://www.mysql.com/ Summary : MySQL - Client [root@fddth03-157-31 /root]# rpm -q -i -f /usr/sbin/mysqld Name : MySQL Relocations: (not relocateable) Version : 3.23.33 Vendor: (none) Release : 1 Build Date: Fri Feb 9 02:42:35 2001 Install date: Thu Mar 8 19:49:49 2001 Build Host: mysql-work Group : Applications/Databases Source RPM: MySQL-3.23.33-1.src.rpm Size : 14793480 License: GPL / LGPL Packager : David Axmark <david@mysql.com> URL : http://www.mysql.com/ Summary : MySQL: a very fast and reliable SQL database engine Description : As you can see, these are all from the same source & version so there should not be any compatibility issues. Has anyone tried this with the same version of mysql? is it a version incompatibility problem? When compiling php I used ./configure --with-mysql=/usr ... --------------------------------------------------------------------------- [2001-04-03 11:25:53] rasmus@php.net I tested on 2 boxes using your exact script. Works perfectly. If this was broken thousands of scripts out there wouldn't work. Check that your libmysqlclient version matches your mysql server version. --------------------------------------------------------------------------- [2001-04-03 11:20:56] jules@acris.co.uk Example script: mysql> use test; mysql> create table mytable (a int primary key auto_increment, b int, c int); <?php mysql_connect("localhost","root","bannerjee"); mysql_select_db("test"); mysql_query("insert into mytable values (null, 5, 6)"); echo mysql_insert_id(); $res = mysql_query("select last_insert_id()"); $row = mysql_fetch_row($res); echo "<BR>$row[0]"; ?> Example output: 722 8 Mysql 2.23.33; using the library provided with mysql (ie configure --with-mysql=/usr). --------------------------------------------------------------------------- Full Bug description available at: http://bugs.php.net/?id=10138