On Sun, 26 Oct 2003 06:30:11 +0100, SIMON Cedric wrote: > For your query, try "SELECT MAX(id) FROM table" > That works with mysql.
That should "work" with most databases, but what happens if there's a new insert between the original insert and the SELECT statement above? This _could_ be solved by locking the table before the insert, and then unlocking it again after you've select the maximum id from the same table. -- Tore Aursand <[EMAIL PROTECTED]> -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]