So what i should really do is like this:
$anotherQuery = "select mysql_insert_id(UserID) from user";
$resultUserID = mysql_query($anotherQuery);
is that corerct?
Jack
[EMAIL PROTECTED]
"There is nothing more rewarding than reaching the goal you set for
yourself"
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: Jacky@lilst <[EMAIL PROTECTED]>; Jason Murray
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, January 19, 2001 12:36 AM
Subject: Re: [PHP] Not quite relevant question about coding and query
> Addressed to: "Jacky@lilst" <[EMAIL PROTECTED]>
> "Jason Murray" <[EMAIL PROTECTED]>
> <[EMAIL PROTECTED]>
>
> ** Reply to note from "Jacky@lilst" <[EMAIL PROTECTED]> Fri, 19
Jan 2001 13:15:13 -0600
>
> What happens when more than one person updates the tables at nearly
> the same time?
>
> a - insert record 9
>
> b - insert record 10
>
> a - get max ID = 10
>
> b - get max ID = 10
>
> Something doesn't look right here....
>
>
> What you are looking for is mysql-insert-id()
> Get the id generated from the previous INSERT operation
>
>
> http://www.php.net/manual/en/html/function.mysql-insert-id.html
>
>
>
> >
> > thanks for Jason:-) Lucky the ID is sequential. That was command I
> > was looking for. cheers Jack [EMAIL PROTECTED] "There is
> > nothing more rewarding than reaching the goal you set for yourself"
> > ----- Original Message ----- From: Jason Murray
> > <[EMAIL PROTECTED]> To: 'Jacky@lilst'
> > <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent:
> > Thursday, January 18, 2001 11:56 PM Subject: RE: [PHP] Not quite
> > relevant question about coding and query
> >
> >
> > > > $query = "insert into user values
> > > ('firstname','lastname','address','phone')";
> > > > $resultinsert = mysql_query($query);
> > > >
> > > > $getID = "select userID from user"; // Will this get me the
> > > > // Id of the record I just
inserted?
> > > > $resultID = mysql_query($getID);
> > >
> > > No, it won't - it'll return every userID in the table.
> > >
> > > If your userIDs are sequential, you can just select "MAX(userID)"
instead
> > > of userID.
>
>
> Rick Widmer
> Internet Marketing Specialists
> http://www.developersdesk.com
>
--
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]
