Auto incremented id

[leung]

I know there is a mysql_insert_id() that returns the value of an auto-incremented key but I am not using mysql database but using MS Access. Is there such command for odbc ?

[PHPdev]

You probably have already thought of this, but you can always do a "select Max(id) from table"

I am fairly certain that Access always increments up, and does not try and fill holes.

PHPdev

[Lars_Berg]

You should never use select max(id) for this purpose.

Use the query

select @@identity

instead.

[leung]

Thanks guys! Both method works great 🙂