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);

        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:


Mysql 2.23.33; using the library provided with mysql (ie configure --with-mysql=/usr).


Full Bug description available at:

PHP Development Mailing List <>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to