no it will keep it very well. In fact most common errors with this function
is that it still keeps the same value when you do something wrong.
This issue is described in more details on every single manual that has
LAST_INSERT_ID() in it - read where you found it ... it is written there ...
I am sure ...
However, on my opinion this function is very reliable. I use it a lot when
have to create a script which splits some few huge tables into a dozen of
well designed ones. Because redesigning the database you really have to
relate your data to each other. LAST_INSERT_ID() does a good job.
Cheers,
Maxim Maletsky
-----Original Message-----
From: Mark Lipscombe [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 25, 2001 5:28 AM
To: Maxim Maletsky
Cc: 'Jacky@lilst'; [EMAIL PROTECTED]
Subject: RE: [PHP] last_insert_id function
Someone jump in here and correct me if I'm wrong, but by the time you
get around to executing the second query, LAST_INSERT_ID() from MySQL
isn't necessarily going to be the desired value, because another record
may well have been inserted in that time?
On 24 Jan 2001 18:25:27 +0900, Maxim Maletsky wrote:
> for example:
>
> $SQL = "INSERT INTO users SET name='Maxim', surname='Maletsky'";
>
> now you have to insert into another table where you need to relate that
user
> to the entry:
>
> $SQL2 = "INSERT INTO questions SET question='how did you sleep?',
> made_by=LAST_INSERT_ID()";
>
> LAST_INSERT_ID() will be here equal to the auto_incremented id of the
first
> $SQL statement.
>
> Hope this helps,
> Maxim Maletsky
>
>
> -----Original Message-----
> From: Jacky@lilst [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, January 25, 2001 7:16 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP] last_insert_id function
>
>
> I got this quote right out of the php manual. My Id field happen to be
type
> BIGINT as it said so I tried using LAST_INSERT_ID(); and turn out to be
> error said "unidentified function". Any clue?
> *******************************************
> mysql_insert_id() converts the return type of the native MySQL C API
> function mysql_insert_id() to a type of long. If your AUTO_INCREMENT
column
> has a column type of BIGINT, the value returned by mysql_insert_id() will
be
> incorrect. Instead, use the internal MySQL SQL function LAST_INSERT_ID().
> ********************************************
> Jack
> [EMAIL PROTECTED]
> "There is nothing more rewarding than reaching the goal you set for
> yourself"
>
> --
> 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]
