>-----Original Message-----
>From: Jason Murray [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, January 18, 2001 9:57 PM
>To: 'Jacky@lilst'; [EMAIL PROTECTED]
>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
>
>--
>
Im no expert...I am learning this stuff "as we speak"....but shouldn't
mysql_insert_id() do it?
Cheers,
Dave
--
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]
