MySQL - Getting Row# (id) After an INSERT

[edh]

I have a database with columns "id","col2", and "col3". Col1 "id" is the primary key, and is autoincromented when a record is added.

After INSERTing a record into a MySQL database, is there a way to get the autoincremented value of "id" without having to do another mysql_query() on the database? ie. is there a mysql function or php function to call to get that "id" value just INSERTed?

Ed

[cgraz]

Take a look at mysql_insert_id()

Cgraz

[edh]

Thanks. I think that will do the trick for me.

Ed