Hi,
To use mySQL's internal function, try something like this:
mysql_query("insert into mytable values(1,2,3)");
$rs = mysql_query("select LAST_INSERT_ID() from mytable");
$theLastInsertedID = mysql_result($rs,0,0);
""Jacky@lilst"" <[EMAIL PROTECTED]> a écrit dans le message news:
05f701c0865b$a2fe61e0$[EMAIL PROTECTED]
> I did try already.
> What I did was I assign value from LAST_INSERT_ID(); onto a virable after
I
> run the first insert query the same way we do to mysql_insert_id
> and the result when the page is executed, it said " unidentified function"
> which of course because php does not know LAST_INSERT_ID like you said
> previously.
> By the way, what even drive me crazy more is that with using
> mysql_insert_id();, it returns me value 0 (zero) which I suspected it
comes
> from the fact that data type of that field is BIGINT, correct me if I'm
> wrong.
> any thought?
> Jack
> [EMAIL PROTECTED]
> "There is nothing more rewarding than reaching the goal you set for
> yourself"
> ----- Original Message -----
> From: Maxim Maletsky <[EMAIL PROTECTED]>
> To: 'Jacky@lilst' <[EMAIL PROTECTED]>; 'Mark Lipscombe'
> <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Wednesday, January 24, 2001 4:06 AM
> Subject: RE: [PHP] last_insert_id function
>
>
> > I am not really sure about this one, but the first thing I would do is
> that
> > I would try it.
> >
> > It could be though ...
> >
> > Cheers,
> > Maxim Maletsky
> >
> > -----Original Message-----
> > From: Jacky@lilst [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, January 25, 2001 7:53 AM
> > To: Maxim Maletsky; 'Mark Lipscombe'
> > Cc: [EMAIL PROTECTED]
> > Subject: Re: [PHP] last_insert_id function
> >
> >
> > 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]
> >
>
>
> --
> 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]
