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

On 14 Apr 2003, Andrew Lindeman wrote: > Is this really a bug? I think it's just a confused user, but I want to > be sure before making it bogus. It's hard to say and in some ways doesn't even matter because it appears his problem exists in 4.1.2 but doesn't in 4.3.0 so even if it was a bug, it's been fixed. Although, ideally if resource became optional fairly recently we'd have a <note> on when that happened, that would be standard procedure. So, you may want see if that's the case here ;) On a related note, here's a user comment found at php.net/mysql-insert-id "Note that if you have more than one database link open, you need to tell it which one you want the last insert ID for, MySQL won't guess." IF that's true then it'd be a phpdoc bug as the docs make it seem the most recent of the two connections would be used. I guess one of the ext/mysql guys would have to clarify. Also, in this scenerio, Stefan might be using two connections... Regards, Philip > 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: ßY¥–W_– > > Ó¿Y[U¯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 > -- > Andrew Lindeman <alindeman@php.net> > > > -- > PHP Documentation Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >