[PHP-DEV] PHP 4.0 Bug #10138 Updated: mysql_insert_id() returns incorrect value
ID: 10138
User Update by: [EMAIL PROTECTED]
Status: Closed
Bug Type: MySQL related
Description: mysql_insert_id() returns incorrect value
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/DatabasesSource RPM: MySQL-3.23.33-1.src.rpm
Size: 437510 License: GPL / LGPL
Packager: David Axmark [EMAIL PROTECTED]
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/DatabasesSource RPM: MySQL-3.23.33-1.src.rpm
Size: 2697037 License: GPL / LGPL
Packager: David Axmark [EMAIL PROTECTED]
URL : http://www.mysql.com/
Summary : MySQL - Client
[root@fddth03-157-31 /root]# rpm -q -i -f /usr/sbin/mysqld
Name: MySQLRelocations: (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/DatabasesSource RPM: MySQL-3.23.33-1.src.rpm
Size: 14793480 License: GPL / LGPL
Packager: David Axmark [EMAIL PROTECTED]
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 ...
Previous Comments:
---
[2001-04-03 11:25:53] [EMAIL PROTECTED]
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] [EMAIL PROTECTED]
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
--
PHP Development Mailing List http://www.php.net/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] PHP 4.0 Bug #10138 Updated: mysql_insert_id() returns incorrect value
ID: 10138
User Update by: [EMAIL PROTECTED]
Old-Status: Closed
Status: Open
Bug Type: MySQL related
Description: mysql_insert_id() returns incorrect value
Previous Comments:
---
[2001-04-03 11:25:53] [EMAIL PROTECTED]
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] [EMAIL PROTECTED]
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
--
PHP Development Mailing List http://www.php.net/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] PHP 4.0 Bug #10138 Updated: mysql_insert_id() returns incorrect value
ID: 10138
User Update by: [EMAIL PROTECTED]
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] [EMAIL PROTECTED]
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/DatabasesSource RPM: MySQL-3.23.33-1.src.rpm
Size: 437510 License: GPL / LGPL
Packager: David Axmark [EMAIL PROTECTED]
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/DatabasesSource RPM: MySQL-3.23.33-1.src.rpm
Size: 2697037 License: GPL / LGPL
Packager: David Axmark [EMAIL PROTECTED]
URL : http://www.mysql.com/
Summary : MySQL - Client
[root@fddth03-157-31 /root]# rpm -q -i -f /usr/sbin/mysqld
Name: MySQLRelocations: (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/DatabasesSource RPM: MySQL-3.23.33-1.src.rpm
Size: 14793480 License: GPL / LGPL
Packager: David Axmark [EMAIL PROTECTED]
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] [EMAIL PROTECTED]
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] [EMAIL PROTECTED]
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
--
PHP Development Mailing List http://www.php.net/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
