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]
