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

Is this really a bug? I think it's just a confused user, but I want to be sure before making it bogus. --Andrew On Mon, 2003-04-14 at 17:20, Stefan_255 at hotmail dot com wrote: > 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: zh�q��5 > �H��(http://bugs.php.net/fix.php?id=23214&r=gnused -- Andrew Lindeman <alindeman@php.net>