From: Thimble Smith
Date: March 16 1999 4:35pm
Subject: Re: Can I get a field when inserting a row?
List-Archive: http://lists.mysql.com/mysql/340
Message-Id: <19990316093555.B10542@desert.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

On Tue, Mar 16, 1999 at 02:56:51PM +0100, Jochen Haeberle wrote:
> I am no SQL professional so I am struggling with the following:
> 
> I have a table "Items" that has a column ID which is autoincrementing 
> and my primary key. Is there any way to know the ID for a new row to 
> this table?

It's easy to do with the mysql_insert_id() function.  Please do
read the manual - this is referenced right next to the information
about auto_increment!

Tim