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.
>
> Jason
>
> --
> 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]
