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]