Regarding your mysql_insert_id() function:
I believe that it works on a connection by connection basis. Therefore, if
you execute an insert, and then call that function, you are guarenteed to
have the correct ID. Look up the LAST_INSERT_ID() function in the MySQL
manual on www.mysql.com for more information.
-Jason Garber
IonZoft.com
At 09:22 PM 11/1/2001 +0100, TD - Sales International Holland B.V. wrote:
Hey list, i'm new to php so bare with me...
got some questions on mysql commands. I'd like to know how the
mysql_insert_id() function works exactly.
First of all how reliable is it? What happens this happens:
Table: (ID int unsigned primary key auto_increment, Stuff text, MoreStuff
text)
(my script)
insert into table values(NULL, bla, bla)
(some other application)
insert into table values(NULL, bleh, bleh)
(my script)
$id = mysql_insert_id
it's not likely that this will happen, but if the site is very/extremely
crowded it could be that there's an insert right after mine but before me
callind mysql_insert_id. As you might guess I'd like to know which ID will be
returned, the one my script created or the one from the other application?
Also what happens if my table is like this:
Table: (Stuff text, ID int unsigned primary key auto_increment, OtherStuff
text)
Thus having the ID on column 2 instead of 1
or like this
Table: (Bla int unsigned primary key auto_increment, Stuff text, Otherstuff
text)
Thus the ID not having the name ID
Or like this
Table: (bla int unsigned primary key auto_increment, id int unsigned primary
key auto_increment, stuff text, otherstuff text)
Thus having 2 auto_increment columns where the 2nd one is called ID (lower
case).
I'm really uncertain about that and couldn't find it back in the manual
does it only read the first column? does this column have to be named ID,
what if ID is another column? what if there is more than 1 auto_increment
column in the table? what happens if some(one)/(thing) else inserts before
calling mysql_insert_id.
One more question (pure curiosity this one) the return value from
mysql_query... is that ever gonna be higher than 1? I assume it can be if the
insert affects more than 1 line right? Also my book says that the return
value is TRUE or FALSE for every command except for an INSERT in which case
it would be 0 on failure and higher on succes. I think that's crap? I'm
guessing it will also return a number for UPDATE's and REPLACE's is that
correct? Are there others?
OK just one more thing, this is for the people from troutworks if they're
monitoring this list. I think the translation of the PHP Bible is
crap! Please complain about it at the translator. The guy/girl
managed to translate (quotes) to (comma's) , and there are a lot of other
wrongly translated things in there, luckily the examples in there got me on
the right path again over and over showing that the translation was incorrect
but it's just confusing like hell. The number of mistakes is unbelievable
(and i'm NOT talking about spelling errors, I'm talking about messy stuff
like calling quotes comma's) and I'm 100% certain it was NOT translated by a
programmer
regards
--
PHP General 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]
--
PHP General 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]
