You should refer to manual, your case depends on the type of your table.
MyISAM tables do assign new number always, and there's some another kind of
table which is reusing numbers the same way you need. I don't remember what
type exactly, so refer to the manual.
-Original Message-
From:
Hi
You should use the following construction:
SELECT LAST_INSERT_ID ();
This will return the last auto-increment value for the current connection.
There is also an API function, and in PHP: mysql_insert_id or something like
this.
-Original Message-
From: Jason Brunk [mailto:[EMAIL PRO