I just had a test :

// code
mysql_query('insert into foo values (1)'); // foo have 2 fields, first one is an auto_increment
var_dump(mysql_insert_id());

// output
Column count doesn't match value count at row 1
int(0)

From the documentation : "mysql_insert_id() returns 0 if the previous query does not generate an AUTO_INCREMENT value."

The documentation seems okay. bogus bug ?

Mehdi

That code doesn't reproduce the bug.  This does:

The table:  

CREATE TABLE `links` (
  `linkid` int(10) unsigned NOT NULL auto_increment,
  `link` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`linkid`),
  UNIQUE KEY `link` (`link`)
) TYPE=MyISAM;

The code:

<?php
$MYDB = mysql_connect('localhost','xxx','xxx');


$links = array('http://hans.zaunere.com',
               'http://zaunere.com',
               'http://hans.zaunere.com',
               'http://nyphp.org',
               'http://lists.nyphp.org',
               'http://nyphp.org'
              );


foreach( $links as $key => $link ) {

   $tmp = mysql_escape_string($link);

   mysql_query("INSERT INTO xxx.links (linkid,link)
                VALUES (NULL,'$tmp')", $MYDB);

   $R_linkid = mysql_insert_id($MYDB);

   echo "<pre>Array key: $key <br>Link: $link <br>Linkid: $R_linkid </pre><br><br>";
}


This is not a bogus bug; MySQL has identified it as a documentation bug, as I pointed to with:

http://lists.mysql.com/list.php?3:mss:9598:200308:ikdgphkkkddmffiinjik

I used the exact code you posted and mysql_insert_id() as documented (on php.net), returning the id 5 for the last insert as the last_insert_id is not reset unless a new auto_increment value is created (as said in the php.net docs).  Running the same script again (with the same data), the id's are 0, as advertised.