Don't you have to do something like this?
$something = mysql_query("into mytable.....");
$result = mysql_query($something);
$rs = mysql_query("select LAST_INSERT_ID() from mytable");
$theLastInsertedID = mysql_result($rs,0,0);
corerct?
Jack
> [EMAIL PROTECTED]
> "There is nothing more rewarding than reaching the goal you set for
> yourself"
> ----- Original Message -----
> From: Alain Fontaine <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, January 24, 2001 4:18 AM
> Subject: Re: [PHP] last_insert_id function: I did already
>
>
> > 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]
> >
>
--
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]
