ID: 10138
Updated by: rasmus
Reported By: [EMAIL PROTECTED]
Old-Status: Open
Status: Closed
Bug Type: MySQL related
Assigned To:
Comments:
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.
Previous Comments:
---------------------------------------------------------------------------
[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).
---------------------------------------------------------------------------
ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at http://bugs.php.net/?id=10138&edit=2
--
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]