Can we store the value retrieved by last_insert_id for later use? say we
want to related 3 queries together and under that case, we will then need to
store the first "last_insert_id value" somewhere and then retrive the second
"last_insert_id value" from the second insert query before both values will
be inserted into the third query.
Can we do that? If not, I will have to come back to mysql_insert_id(); but
it won't work with a field with data type BIGINT, will it? So I guess I
would have to change the data type too, right?
please enlighten me about this
Thank
Jack
[EMAIL PROTECTED]
"There is nothing more rewarding than reaching the goal you set for
yourself"
----- Original Message -----
From: Maxim Maletsky <[EMAIL PROTECTED]>
To: 'Mark Lipscombe' <[EMAIL PROTECTED]>
Cc: 'Jacky@lilst' <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, January 24, 2001 3:36 AM
Subject: RE: [PHP] last_insert_id function
> 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]
