#23214 [NEW]: mysql_insert_id - Never use the function "Blank"

From: Stefan_255 at hotmail dot com Operating system: win2k PHP version: 4.3.0 PHP Bug Type: Documentation problem Bug description: mysql_insert_id - Never use the function "Blank" I copied a few lines of code from the net and got it to work in my own test environment. When I placed the software on the production server (linux PHP 4.1.2) - it only "almost" worked. The problem was that it had lines with statements like: mysql_insert_id(); where strange id's sometimes were returned ! Then, when I changed the code to: mysql_insert_id($con); // The “resource link_identifier” everything was fine. I believe that what happened was that my program received id's from somebody else doing INSERT on the same server? My conclusion was: Never use the function without the "resource link_identifier" ! And then again, - Why should you? In the documentation it says:"If link_identifier isn't specified, the last opened link is assumed." My code was simply: $sql= "INSERT INTO xrefs (referrer) VALUES ('$ref')"; echo "sql $sql <br>"; $result = mysql_query($sql,$con); //$referrer_id = mysql_insert_id(); // FAILED $referrer_id = mysql_insert_id($con); // WORKED OK -- Edit bug report at http://bugs.php.net/?id=23214&edit=1 -- Try a CVS snapshot: http://bugs.php.net/fix.php?id=23214&r=trysnapshot Fixed in CVS: http://bugs.php.net/fix.php?id=23214&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=23214&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=23214&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=23214&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=23214&r=support Expected behavior: http://bugs.php.net/fix.php?id=23214&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=23214&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=23214&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=23214&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=23214&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=23214&r=dst IIS Stability: http://bugs.php.net/fix.php?id=23214&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=23214&r=gnused