I use MySQL+PHP. A field named "id" in a table is set auto_increment from 1. I inserted 6 rows in it, and then deleted the 4th row, that means it still has 5 rows (id#1,2,3,5,6). Could I get the next id (i.e 7) in the php?
have a look at the mysql_insert_id manual pages, particularly the most recent comment.
hth, njm
thank you!
