Re: Not quite relevant question about coding and query

thanks for Jason:-) Lucky the ID is sequential. That was command I was looking for. cheers Jack jacky@activelifestyle.com "There is nothing more rewarding than reaching the goal you set for yourself" ----- Original Message ----- From: Jason Murray <Jason.Murray@melbourneit.com.au> To: 'Jacky@lilst' <jacky@activelifestyle.com>; <php-general@lists.php.net> 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: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >